ColemenWilson Coach

I am pretty sure that color rules don't work on the Filled Gauge chart type. The only controls you have are those here: This is an idea that makes a lot of sense. You could make a suggestion in the and I will be one to upvote it!

Welcome to the Domo Community!

Very strange. Definitely something I would open a support ticket for.

There is a way to allow external users to edit/create their own cards using Domo Everywhere. May be an option for you. Otherwise, it sounds like they are just needing to source data from Domo to create charts outside of Domo. For that I would look at Excel plugin as @david_cunningham suggested or using Domo's Integration…

Why isn't charts as pictures working for you? Have you considered using Domo Everywhere?

Domo has great plugins that will allow you to do exactly what you are describing: More > Admin > More > Tool Downloads > Legacy Domo PowerPoint plug-in OR Domo for Office Add-in

Linked below is my go to checklist for OneDrive issues:

Looks like you'll create a stacked bar chart of some sort. If you provide more information and some sample data I could direct you more.

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: Legend control (i've clicked "Planned" on the legend and that bar dissapeared):

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: 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: CASE WHEN `Department` = 'Sales' THEN CONCAT('S - ',`ID`) ELSE `ID`…

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.