jaeW_at_Onyx Coach

@ST_-Superman-_ i don't want to work through converting pseudo code to real code but i wonder if you could do math along the lines of do the datetime diff. between start_date and close_date. test if the day of week for CLOSE_DATE is < START_DATE (if it is we know there was a weekend in between and we have to subtract 48…

@swagner take a look at FIXED Functions

i could be mistaken, but i believe the env object should include all dashboard filter settings.

@SlickVic check out this article: "Pulling Parameters from the Environment"

@pstrauss the datacrew community, datacrew.circle.so, has a resource that might help you: This API will force domo to render your card. Video Tutorial https://www.youtube.com/watch?v=3ZwlzOlRBbA

I know for a fact they are working on a project in that space. But TBF the query API DOES work and hasn't changed.

@RobynLinden for your use case i would not necessarily care what order the dashboards were created, I just need to be able to set a default order for all users having the ability to set the default order to alphabetical (or anything else) would be nice, but bullet 1 is most important IMHO. I would separate this need from…

The webinar recording is live! We put a ton of Learnings and Resources here. Video Tutorial https://www.youtube.com/watch?v=15nXTopnRcI

I did a python implementation of solving this here: https://www.youtube.com/watch?v=3ZwlzOlRBbA

@JenniferGibson , @MichelleH used Redshift not Magic to get the job done. Beast Modes run on Adrenaline (Domo's database layer), Magic runs in a different environment. Even though many of the functions use similar syntax there is not always 1:1 parity in implemented functions, AND they are not processed in the same space.…

@LiliRestrepo all beta features are available in domo-dojo.domo.com. you don't have to die of Fomo.

@ST_-Superman-_ on paper i think i agree with you but i'm not sure what you want the end experience to be. when you choose a value with the Variable Picker, you want the value of the Variable Picker represented on the Axis? for stuff like this might be helpful to post a quick video of what you mean.

@RobynLinden like ... just in the preview? or as an output dataset? would you want it as part of the execution details page? in the immediate term, I just always tell people to use a GROUP BY or REMOVE DUPLICATES tile before they do a JOIN and that solves any row growth problems... unless there's a NULL in the column.…

@NoahFinberg I LOVE THIS!!!

@andersson_morales19 i think you need CASE and aggregation. so something like CASE WHEN count(column) + count(other_colum) <= 3 AND count(column_3) + count(column_7) <= 3 THEN ... WHEN count(column) + count(other_colum) <= 3 AND count(column_3) + count(column_7) <= 3 THEN ... END

@FXM32 Domo does retain dataset history in Vault, but that's supposed to be a recovery tool not dataset snapshots that end users can flip between. Given that your "freezing mechanism" should tightly align with business logic, it makes sense that you should apply that business logic as an artificat in your dataset that you…

@andersson_morales19 post a sample of your dataset please.

just add a column date_is_not_null and use a CASE statement. CASE when date is null then 0 else 1 end Kimball would say that all dimensional columns should never contain a NULL. Can you fill it?

@SaloniShah post a picture of what you're currently doing / strugglign with.

for the original use case using a formula tile and COALESCE() will be a much cleaner (and recycle-able) design pattern in other parts of the platform. I particularly enjoy the fact that COALESCE is a SQL standard and not bespoke to MAGIC ETL. My challenge with setting data types in the INPUT dataset is last time i looked…

@SaloniShah is the data actually duplicated in your dataset? If so that's probably something to be concerned about if it's not intentional. Take a look at the connector that's bringing in the data, is it set to APPEND or REPLACE? Is the data actually duplicated or are just a few rows duplicates? If you run the connector…

@damen to be more specific, you should (probably) impelment the metric @RobSomers is describing as a Beast Mode in Analyzer. Typically we recommend against preaggregating datasets in ETL if we don't have to.

@trafalger I do wonder if you add the index in the UI if the data is indexed as it's being loaded into the table, or if if the index is added after CREATE TABLE AS SELECT ... So i i guess if you wanted to be REALLY fancy you would CREATE TABLE, ALTER TABLE and then load data... but then the table doesn't appear in the UI.

sounds like your question is whether it's possible to use "platform embed + buzz" i don't know the answer,but maybe drop a support ticket. platform embed is a relatively new feature so it'd be unsurprising if the documentation hadn't been updated.

@Jones01 if a user locks their dashboard, then only admins or owners can edit it.

at the domo user conference @MichelleH showed how she used redshift + geometry functions to get that done. https://docs.aws.amazon.com/redshift/latest/dg/ST_Point-function.html try out your trig functions in beast modes, some of them aren't documented.

my approach would be to try to take a timestamp and date_format( hh:mm) that would always round down. to address round up, i'd use a CASE statement so if second() is 30 then hh:mm + 1 minute.

@Sam_Donabedian some functions are available but not represented in the UI. Did you try it? I would be surprised because beast modes are processed in the same engine as dataset views (AFAIK).

yes the "variables beta" will be going live soon and can address this issue. you'll be able to set up a varaible with enumerated values (ex, "full_price" and "mark_down") then you could write a case statement CASE when <variable> = 'full_price' then <col_name> else <other_col_name> END

@Jones01 , "Domo Everywhere" is an umbrella of tools... what specifically are you looking for?