GrantSmith Coach

Hi @Hulachic5 - Do you have any whitespace at the end of your string that isn't being accounted for? Have you copied and pasted the value into your Pivot tile?

Hi @nbrx - It appears the Ads Action Stats endpoint is where you can find the saved posts metric under the action_type: onsite_conversion.post_save". You can get these with the Facebook Ads Advanced connector under: Report: Ad Accounts Ad Account Edge: Insights Columns: Actions Other settings can be assigned as needed but…

Ah the reason I'm not a fan of TIMEDIFF. In cases like this I prefer to use UNIX_TIMESTAMP and math to calculate the difference in seconds between two different timestamps. SUM((CASE WHEN ((UNIX_TIMESTAMP(`Start Time (UTC)`) - UNIX_TIMESTAMP(`Arrival Time (UTC)`)) / 60) <=10 THEN 1 END)) / SUM((CASE WHEN `Case Number` is…

Hi @Chris_Hippo I typically will use Text cards instead of Headers on dashboards as they give you much more options in terms of text color, size and formatting however changing the font face currently isn't an option.

No, anchor links aren't supported in Domo. A somewhat clunky solution would be to utilize pfilters to directly link to different pages with predefined filters but if they navigate their on their own without using those links the filters won't be applied. It'd be difficult to translate the currently selected filters to an…

Hi @Chris_Hippo Currently this isn’t possible to do. Id recommend adding it to the idea exchange. If you want your filters to affect your different cards then they’d have to be all on the same page.

Sounds like a bug. I’d reach out to support to log it and see what they have to say about the issue

Alternatively with the new ETL 2.0 you can set the data type to be a time stamp directly on the Input Dataset Tile under the Configuration tab and then click the gear icon to define how to handle bad values - in your case you can select null:

Can you remove the 'NULL' string in your data before it gets ingested into Domo? Are you able to ingest your data in that column as a string, use a text replace tile to replace the 'NULL' string with the actual null value then use the Set Data Type tile to convert that column to a date or date time?

You can utilize an additional clause inside your case statement to swap the values if necessary: SUM((CASE WHEN `Start Time (UTC)` <= `Arrival Time (UTC)` AND (TIME_TO_SEC(timeDIFF(`Start Time (UTC)`, `Arrival Time (UTC)`)) / 60) <=10 THEN 1 WHEN `Start Time (UTC)` > `Arrival Time (UTC)` AND (TIME_TO_SEC(timeDIFF(`Arrival…

You'd need to add it to your input dataset as the first step, then when you go to add it to your recursive dataset it should have the different values stored in there for when the input is added. Do you have a screen shot of your ETL?

Hi @Ashwin_SG When you tried your recursive dataflow did you add a new column / constant contained the current date and time before your output dataset?

For future reference this is mentioned just above the "Customizing Pivot Tables" section in the knowledge base: https://domohelp.domo.com/hc/en-us/articles/360043429473-Pivot-Table#3. By default there's a limit of 25,000 rows to display. See the section " What are the DataSet row limits for each chart type?" on this…

You can utilize a beast mode to defined the different buckets and then drop your length column into your chart and use the average aggregate on it. CASE WHEN `Years old when moved in` >= 70 THEN '70+' WHEN `Years old when moved in` >= 70 THEN '60' WHEN `Years old when moved in` >= 70 THEN '50' WHEN `Years old when moved…

Thanks @blool1 but that just highlights the new features that are coming out. It doesn't get into technical details about any of the underlying data changing - case in point there's a new activity log type called workbench_JOB which is now different than the old JOB type. When we've configured our data flows to look for…

Hi @brady_price Your beast mode looks incomplete - you have a trailing closing parenthesis. Are you doing anything else with your count like a SUM perhaps? COUNT(DISTINCT `user_id)) over (partition by `rubric_id`) The way Domo functions is that it will run your "query" twice. The first time with the beast mode to return a…

Yeah, it'll automatically filter based on the date or card filters, the period offset won't be able to change but the timeframe they're looking at can. You can always define additional offsets if necessary.

Hi @user048760 Are Just names included in your column and you want to blank it out or is there other information in that column that you need to retain except for the name? If it contains just the name and you want to set it to one if it is populated you could utilize a formula tile in Magic 2.0 with this code: CASE WHEN…

I’d recommend using a date dimension with custom defined offsets. Using the custom date offset dimension you can have the current value and the value from 12 months ago. This will simplify your graphing and correctly calculate the current month to the partial month from the previous period . I’ve done a Previous write up…

Hi @jgillman You'll need to aggregate your data and count all of the subscriptions before attempting to calculate the weighted average. You can't aggregate an aggregate in a beast mode so pre-aggregation is required. Once you have the number of subscriptions counted you can then use that new field in your beast mode to…

@Imbesat - Are you aggregating your data from your dataset in your table card or are you just displaying your dataset? You may also be able to utilize DataSet Alerts for individual rows. https://domohelp.domo.com/hc/en-us/articles/360042925994-Creating-an-Alert-for-a-DataSet

@AkshayAnand2 - This KB article may help explain Summary Numbers: https://domohelp.domo.com/hc/en-us/articles/360043428753-Configuring-Your-Chart-Summary-Number

You can use the value mapper to map the 0 to an empty string (click the gear icon on the replacement field - select empty string) before you use the Set Column Type.

You're attempting to aggregate twice (COUNT(SUM()) which Domo doesn't like. Are you grouping based on the order ID at all? Do you have multiple records for the same order id in your dataset? In simple business terms what are you attempting to calculate? Why are you attempting to count the sum of line items? Do you just…

You can add another SQL transformation (not a table one) to have it drop the final table if it exists before you run the word_cloud function call because in the MySQL database that's spun up it'll create the table but won't ever remove it when you attempt to create it again and cause the table already existing error. DROP…

Hi @Jobur You can utilize a beast mode to create buckets for your margin % the following beast mode works since it evaluates the first condition it finds to be true and exits. If you want to sort by these values you can make another beast mode with the same logic but instead of the string (75-100%) you can return a number…

Hi @DKCloud9 You’ll define the schema of your data set with a DataSetRequest object and pass that into when you create your dataset. There is an example of how this works on the GitHub repository specifically lines 14-17 (creation) and 33-38 (updating)…

Another option is to utilize a Value Mapper tile to search for values of 'x' and replace it with 1 or 0 (default value) if it's not found. Then use a Set Column Type tile to convert it from a string to a numeric. You can copy and paste the following code into your dataflow to replicate this logic (tweak your dataset and…

Hi @user048760 If you have Magic ETL 2.0 you can use a formula tile and a case statement to swap it out to a 1 in a new column: CASE WHEN `ExcludeOnline` = 'x' THEN 1 ELSE 0 END Alternatively you can do this as a Beast Mode as well if you need it just on the card. If you don't have Magic 2.0, you can wait when it comes GA…

You could utilize Magic ETL dataflows to check the date on the data and either split it out and archive it or remove it from the dataset depending on your company's data retention policy.