Best Of

Re: Remove Inherited Color Rules from Drill

I completely agree and fully supportive of this. For example I have a bar chart card with say 3-4 series of different colour rules being applied, but our drill down is a table card which can be hundreds and thousands of rows, but the inherit colour rules means when it is drilled down, the colours applied to each rows of the table which is way to much on the eyes.

I will give the below recommendation a try.

https://community-forums.domo.com/main/discussion/comment/64781#Comment_64781

Edgar_Movius

1

Re: Remove Inherited Color Rules from Drill

It is especially hard on the eyes when a chart card with color rules drills down to a table where colors are applied to all the rows. My work-around is to write a beast mode to rename the impacted fields. As a result, I have a lot of "no color" beast modes across my datasets whose sole purpose is to make drilling down to a table card visually pleasing.

LAFligg

3

Re: Help with the SUM function, I get "An issue has occurred during processing"

You'll need a window function to aggregate an aggregate and a count distinct to count the users only once.

COUNT(DISTINCT CASE WHEN COUNT(`userid`) OVER () > 100 THEN `userid` END)

GrantSmith

1

Domo Everywhere Editor Embed Cookie Issue

Hi,

Anyone having issues with the Edge browser. Whenever our users access domo embedded they are greeted with this button without explanation. I think this is to do with blocking third party cookies.

Jones01

1

Re: Display Values used to calculate Summary Value

You can show multiple summary numbers in the summary number box by creating a beast mode to show those numbers. Here's one previous post that talks about how to construct the beast mode.

https://community-forums.domo.com/main/discussion/32344/formatting-multiple-summary-numbers-with-commas

It's a pretty convoluted beast mode. I have started to move away from this and create another card that would sit right above the other card and use the multi-value gauge card to display the summary information. This works well if you intending your users to look at an entire dashboard to view the information. If you don't have a dashboard page constructed, and are just having a single standalone card, this might not work for you. Here's what it can look like.