Best Of

Re: COUNT(DISTINCT *) desconsidering only one filter

Filters will apply to all rows in your dataset so what you’re wanting to do isn’t possible. You might be able to get around it using a segment and tell it to not apply those filters you wish to ignore.

GrantSmith

1

Re: Flex Table Sorting by Pct Change

Typically it’s just

(‘New’-‘old’)/(‘new’) but it depends on how you have your percent change metric defined in the card settings. Which method are you using?

GrantSmith

1

Re: How to find a two digit number in Replace Text

I would not recommend replace text for this. I would create a lookup table with the country id's and the country name and join that to your main dataset in the ETL. You can use Domo Webform or upload an Excel file to create the list of the values. Add that file to your ETL and join on country id. This will be much easier to maintain going forward.

MarkSnodgrass

2

Re: Formula to Remove Duplicates and keep Max Value

Hi @Shumilex

Can you use a group by name account and date and just use the MAX aggregate to get the highest balance?

GrantSmith

1

Re: Conditionally Format Data Label Fill Color on Grouped Bar + Line Chart

Unfortunately, you can't include HTML in that card type. It would be worth submitting it in the Ideas Exchange for a future enhancement, though.

MarkSnodgrass

1

Re: Line plus grouped chart - getting Y axis and 1st series on left scale, 2nd series on right scale

The closest thing you can do is to choose Sync Value Scales under the General Chart Properties. This will make the left and right be the same.

I would think it would make more sense to have your percentage field be the line and your two order counts be the bars in the series. You'd then be able to format the line as a percentage and it would be more evident between which values are percentage and which values are counts.

MarkSnodgrass

2

Re: Custom Color Range

Here is an example I came across recently. Google sheets allows you to set a theme with a number of accent colors. Charts automatically use those colors, and if you have more series than accent colors, then it automatically chooses gradients of those theme colors. Something like this would be brilliant.

At the very least, it would be nice to be able to set-up gradients with 2-3 base colors selected. Or, to just be able to select some number of branded theme colors for your instance that cards can default to (i.e. manually select somewhere between 5 and 30+ colors for cards to default to)

Google Theme.png