GrantSmith Coach

Looking at the existing Azure connectors they don't appear to fit your needs with that API endpoint. the JSON connectors may allow your to connect to it but I haven't used those heavily so I can't answer for certain. You may need to write a custom connector.

Graphsql endpoints can work in Domo but a connector needs to be written as each endpoint is unique in it's processing and data being returned. There are some prewritten connectors for things like Facebook which uses Graphsql in the connector library.

@Ashwin_SG Glad you got it sorted out! If you could accept my solution so that others who are searching for your issue could find it more easily I'd appreciate it.

As someone who can't seem to stay away from the Dojo I agree but make sure you have access to all the features of the dojo and not just some subset of things you can do like it currently is when you access the Dojo via mobile: I logged Respect Load Desktop Website on mobile a while back to make sure we can get access to…

Your days are negative because your date assigned is coming after the application started date. And because -27 is less than 15 they're all falling into the bucket. You have a few options. One is you can utilize the ABS function to convert any negatives to positive so in you cases where the difference is -27 it'll evaluate…

Hi @Hiraayub This is because you have your dates swapped. Which date is supposed to come first? You need to do your end date - your start date since the end date will be greater. Swap `Application Started` with `Date Assigned` such that `Date Assigned` is coming first.

Glad you got it figured out!

Hi @George_LL This sounds like a bug. I would reach out to Domo support and raise this issue with them.

Hi @Tsharma8724 The main difference is from a security standpoint. The cloud connector will have Domo connect directly to your database and are typically easier to get up and running. With workbench Domo doesn’t have direct access to your database but rather you have a local windows machine that will connect to your…

Hi @WorldWarHulk I'd be a bit wary of using just the beast mode name to check if it's a duplicate as you can have the same named beast mode on multiple different datasets doing the same calculations but with different columns. What I've done in the past is utilized a Magic 2.0 ETL and the Domo Dimensions - Beast Modes…

Hi @Pierce13 Typically when doing period over period charts I'll use a custom offset dataset along with bar + line type graphs to display prior values. I've done a write up previously on this methodology here: https://dojo.domo.com/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest In a line +…

@nbrx - Glad you were able to get the metrics. If you could mark my answer as accepted so others can more easily find it in the future I'd appreciate it. Thanks!

Hi @user000253 You can use a beast mode to create your custom buckets (Name 1 & Other) and use that as your quick filter. CASE WHEN `name` = 'Name 1' THEN `name` ELSE 'Other' END This is assuming your column is called 'name'

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.