jaeW_at_Onyx Coach

dumb question, but does your beastmode render as expected as a summary number in a table card?

Sorry i'm late to the party, but I wanted to clear up a few points. MySQL dataflows execute in a standard MySQL 5.6+ database environment. The UI is hiding some automated scripting activities. When you create an Add Table transform, you are creating the equivalent of SELECT ... INTO tableName FROM ... @MarkSnodgrass is…

It's behaving as designed. because your CASE statement is OUTSIDE of the SUM, it applies the CASE AFTER aggregation has happened, or to use your language "the case statement is affecting the total instead of the ... the individual values. " To get your total to work as expected you have to put the CASE statement INSIDE of…

@Chris_Wolman take a look at the documentation for Group Scheduling, https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5/Group_Scheduling_for_Workbench_Jobs

you can script the execution of java cli commands as per the documentation. https://knowledge.domo.com/Administer/Other_Administrative_Tools/Command_Line_Interface_(CLI)_Tool see the section on 'Scripting' a dataflow is an ETL (Magic or MySQL) whereas a dataset implies a dataset created via a connector (so 'a Facebook…

Oh that's you! Hi. It's me.

You cannot Group_Concat in Beast Mode / Analyzer. You have to do this in SQL or Magic AFAIK

@Khan_Naziya you're using confusing language sorry, it's not clear to me if you're asking for an UPSERT scheme which keeps only the most recent version of each row or if you're looking for a partition scheme where you only keep the block of data from the most recent month. OR if you're looking for a way to report if the…

as an extension to @GrantSmith 's idea, on your input tile in Magic 2.0 you can set the desired data type (instead of using an ALTER tile). you can also build in error handling that says 'if the column cannot be converted to date replace with a NULL value. You could then output rows where the date column is NULL as a…

https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/Configuring_Each_Connector/Connectors_for_File_Retrieval/Airtable_Connector that's super cool @user068035 !! how does this feature differ from the build-in connector that's part of the Domo library? Does it offer new functionality? I assume you can mass…

if i understand your question, to break it into pieces you should start with: "what percentage of the users does each domain account for" so you need a percent of total calculation. then you want to order your domains by percent of total ascending then you want to keep all domains where the cumulative sum of 'percent of…

sorry. your question without more context does not make sense. could you provide a sample of data, or a spreadsheet of what your data looks like and the math you're trying to approximate?

... this is bad sql. while you can 'make it work'. it will be prone to invisible errors. you can't SUM DISTINCT values. ... or at least... you shouldn't. you can COUNT(DISTINCT) values. I assume you're using sum(distinct) b/c you have multiple rows with the same value repeated. your hope is that if you sum(distinct) you'll…

you can embed video in the form of a document card (but you'd have to upload the video to Domo). you can build a custom app that will run an iframe of a video (like youtube or similar).

AFAIK, Mega tables do not support HTML formatting. HTML tables do, but they don't have all the functionality of Mega Tables (on the fly sorting or scrolling).

@GuitarMan2020 , I'm with @Ashleigh isnofar as your use case / requirement is a bit unclear. what i'm gleaning from here, to boil it down is that you want your report to trigger an alert if a task hasn't already been created. there is a domo_stats dataset called 'tasks' which i assume will give you a list of all your…

send in a quick support ticket and confirm that the connector is still being updated. some of the microsoft connectors floating around the domo library aren't always up to date / in use b/c of API changes. also just ping your question to support they may be able to point you toward a KB article. that said, i'd…

use a Dataset view (beta feature, ask your csm) to isolate the subset of data that you actually need in ETL.. are you running magic or SQL? Magic can start ETL before all the data is loaded into the ETL environment, with SQL you have to wait until all the data is loaded into a table (and indexed if you're using redshift)…

Domo by default does have a limit to how wide datasets can be when stored in Domo. if you're using datagrid you need to be careful how nested objects are treated because with datagrid they just get flattened into a very wide record. consider an array of airbnb_listing dataset. ideally your dataset should be just key value…

my question about how the data is structured is important to the solution to this problem. what is the granularity of the dataset. a window function would get you halfway there sum(sum(amount) over (order by year(date)) -- IF the granularity of the dataset was one row per judge. but if the granularity of the row is one row…

@GrantSmith this is so clever! i love it. but also, @user003454 this will make your data dangerous in untrained hands. maybe consider using drill through to show the chart by region and then when a user clicks it navigates to a chart that shows the data by segment. when you structure the data the way Grant is proposing if…

lol... so now you need to use parenthesis to group your booleans. right now your tests are for the result of ... date1 AND date2 AND prod1 OR prod2 what this means is ( date1 AND date2 AND prod1 ) OR prod2 in other words, you'll get the correct number if you're prod1 and between specific dates, OR if you're prod2 across…

in the original code you forgot an END. when formattting your code, take the time to spread it across lines. that way you can ask yourself, "how should this codeblock begin, how should it end? sum( CASE WHEN `Date` >= ( DATE_ADD(CURRENT_DATE(),interval -15 day) ) -- these parenthesis are superflous AND `Date` <= (…

@GrantSmith sorry, your code may be good, but your reason is innacurate. you absolutely CAN aggregate across ROWS with the SUM column and include NULLS. so SELECT SUM( 5 4 null 6 ) as myTotal FROM table will return the expected value of 15. you CANNOT aggregate across columns (on one row) and include nulls. SELECT 5 6 4 +…

I'm pretty confident that Dashboard embed is a premium feature. Please confirm with your CSM.

@hamza_123 not to be that guy ... but why do you want to do this? data stored in Domo is assumed to be in UTC by the viz layer. if you change the timezone in ETL to any other time zone, then the Viz layer will think that it's UTC AND THEN convert the timestamp to your company time ... which will be wrong b/c you adjusted…

a series of nested IFNULL statements will get the job done as per Grant's recommendation, but have a look at COALESCE() it will return the first non null value in a chain. if you want to write it as a case statement then do a series of null checks case when colA is not null then colA when colB is not null then colB when…

what is the shape of your data? what is the granularity? (one row per judge per year? one row per judge when they were made 'active?') if it's one row per judge, then just do count(distinct judge_id) as a beast mode, and then Active Date on the axis. if it's one row per year, then you want to filter where year(active_date)…

At Grant, I'm not an expert on the indexing thing but I believe MAX(SUM(X)) over () would be accurate for all use cases, whereas Max(Max(x)) would be wrong if you're not showing the data in the chart at the row level. Example if there were two or three transactions per date, Max(Max(() would show the maximum of the max…

@swagner in SQL parlance that's called a cumulative sum. Which I mention because eventually you'll want to use a PARTITON BY which will reset your counter based on an Item, Customer or Year.