ColemenWilson Coach

Yep! You can do this in Admin > Dashboards > (select the dashboard checkmark) > Edit > Move Dashboard > Top Level Dashboard

Append! Use Magic ETL to: 1. Match column names and data types where appropriate (like date) 2. Get both datasets in the same granularity with same aggregation 3. Remove unneeded columns 4. Append the data together rather than join.

For the first part of your question, that is just the way Domo is. For the second part, yes. You could do this using a variable and also by clicking on the legend on the card to hide that bar. Variables: https://domo-support.domo.com/s/article/7903767835031?language=en_US Legend control (i've clicked "Planned" on the…

Have you tried using nested beastmodes? You may need to have nested beastmodes enabled by your CSM from Domo. You could try SUM(DISTINCT Price) FIXED (BY Product ID) as Beastmode 1 and then: SUM(SUM(`Beastmode 1`) FIXED ())

Is ETL out of the question?

Wouldn't the average be 0.58? Just wrap your beastmode with AVG() AVG((Oil Usage / Run Time Hours) * 24) Or change the aggregation type to Average for that field.

Here is the solution to your BLUF: 1. Use Group By tile in Magic ETL and the following formula: GROUP_CONCAT(DISTINCT CASE WHEN Treatment IN('Consult','Testing','Evals','Preop') THEN Name END) You don't have a nurse identifier in your sample data so I added one called "Name" Results: This will show which nurses saw each…

Do you have "Show navigation" disabled?

It should be there. Ensure you have your card configured in the following way:

Could you share screenshots of your setup in analyzer? Also what do you mean when you break up the statement? The beastmode appears correct and should be returning values.

Yes, you can use the rank and window tile in Magic ETL: Here is KB article with more info: https://domo-support.domo.com/s/article/360042922814?language=en_US go down to the "Row Number" section. If you want a bit more in an ID value, you could take the row number and combine it something using a formula tile, for example:…

I don't believe you need them enabled, do you mean Nested Beast Modes? For those you can reach out to your CSM to have them enabled.

MAX(Total Clicks) OVER( PARTITION BY Model) Then create a filter to leave only max rows:

I would recommend opening a support case with Domo.

If you are looking for anything "like" GET then you can use the following beastmode and then apply it as a filter: CASE WHEN UPPER(`yourField`) LIKE '%GET%' THEN 'In' ELSE 'Out' END If you want only rows where the field is equal to GET then you would use: CASE WHEN UPPER(`yourField`) = 'GET' THEN 'In' ELSE 'Out' END

1.Go to your dashboard and select the sharing icon: 2.The sharing menu displays. 3.Select Schedule as Report. 4.The schedule report modal displays. 5.Enter the desired start and end dates in the appropriate fields.

You need to click into Cards and then you will see something like this:

In Magic ETL you can use REGEX_REPLACE(). Here is the formula: REGEXP_REPLACE(your_column, '[^0-9]', '')

This can be done from More > Admin > Cards > Dashboards and App Pages (the kebab icon) > (type the dashboard name) > Select All Visible >. Edit > Lock Cards

The best way is in a beast mode: CASE WHEN UPPER(`yourField`) IN('S','T') THEN 'Out' ELSE 'In' END Then use this field as a filter on the card/page.

Won't be too bad. Output becomes only input. Remove duplicates tile to prevent any duplicate rows. Set update to manual.

You could just make the dataset recursive and then you could remove the inputs.

@Lu_zhang this should help! https://domo-support.domo.com/s/article/4408174643607?language=en_US I used example #1.

If you remove the background from your dashboard that will go away. Or you can make the filter card wider on the page and it should also go away.

Yep then Group Concat is the way to go! See a basic MagicETL setup below (just swap `state` for `Page` and `Sales Rep` for `Group`: If you are using MySQL dataflow instead, use GROUP_CONCAT() and be sure to have a GROUP BY `page` in your query.

I am not sure exactly the format you are hoping to have, but if you could provide a screenshot or a data table from excel or something showing the format I could help out. I think maybe you are looking for a concatentation into a single column, which you could accomplish using GROUP_CONCAT()…

Awesome!

You'll need to use the pivot/unpivot tiles in magic ETL. More info here: https://domo-support.domo.com/s/article/360044951294?language=en_US Please let me know if you get stuck and I can help out!

You could submit that feedback to the Domo connector team through the ideas exchange here: https://community-forums.domo.com/main/categories/ideas/%40localize_url%28%27/domo-central/help%27%29 Alternatively, you could change the update method to append instead of replace and then overtime you would have a history greater…

@ArborRose had this exact problem, here is his solution: https://community-forums.domo.com/main/discussion/58361/format-as-number-without-comma