Best Of

Re: How to hide Pie Chart total and include % in the data label

You can hide the total number in chart properties as shown below:

Screen Shot 2023-10-01 at 5.30.01 PM.png

You can display the % values in chart properties as well as shown below:

Screen Shot 2023-10-01 at 5.31.57 PM.png

ColemenWilson

3

Re: How do you build a filter for a date range?

CASE WHEN `DateValue` >= LAST_DAY(CURRENT_DATE()) + INTERVAL 1 DAY - INTERVAL 12 MONTH
AND
`DateValue` <= LAST_DAY(CURRENT_DATE()) - INTERVAL 9 MONTH THEN 'In' ELSE 'Out' END

ColemenWilson

1

Re: Hi all，how to insert rows in table card in domo without using ETL？

I think a bit more information would be useful, as there are many ways to add additional rows to a table card in Domo without using ETL, such as:

Remove a filter or filters
Change the date range
Choose different fields
Add/remove aggregation
Update the data source
Change the data source
Use a different data source type all together
Inline Editor https://domo-support.domo.com/s/article/360042933754?language=en_US

ColemenWilson

1

Re: Custom / Manual Sort Order

Create a duplicate beast mode with the same logic you're using to create the ranges but instead of returning the ranges return a number to sort on (0, 1, 2, 3 etc) then use that new sort beast mode as your sort on your card.

GrantSmith

1

Re: Congratulate our newest Community Coach, @marcel_luthi! 🎉

I LOVE seeing this. Congrats @marcel_luthi on this huge accomplishment and thanks for all you are doing for the Domo Community

MarkBoothe

1

Re: Congratulate our newest Community Coach, @marcel_luthi! 🎉

Thanks for continuing to believe in our mission and engaging with your peers on our Community Forums at Domo, @marcel_luthi - Keep crushing it.

Eddie Small

1

Re: Organize values on X-Axis

Yeah it is because the values are case sensitive. So in the beastmode it doesn't find a match for "Senior Managers" because the "M" is capitalized in the case statement but not in the data, so it places it in position 7 from the ELSE part of the statement. A great way to protect against this is to wrap the values in LOWER() and then type out the text values as all lowercase.

CASE WHEN LOWER(`split_detail`) = 'ceo' THEN 1
WHEN LOWER(`split_detail`) = 'head of business' THEN 2
WHEN LOWER(`split_detail`) = 'key management personnel (kmp)' THEN 3
WHEN LOWER(`split_detail`) = 'other executives/general managers' THEN 4
WHEN LOWER(`split_detail`) = 'senior managers' THEN 5
WHEN LOWER(`split_detail`) = 'other managers' THEN 6
ELSE 7 END

One other suggestion would be to change the chart type to be a 100% stacked bar since you are comparing two % values that will always sum to 100%. Line charts are typically used to show trends over time.

ColemenWilson

2

Re: Organize values on X-Axis

Rewrite it like this and ensure that there isn't aggregation on the sort, in the screenshot you have it set to COUNT. It should look like this:

Screen Shot 2023-09-26 at 9.08.10 PM.png

CASE WHEN `split_detail` = 'CEO' THEN 1
WHEN `split_detail` = 'Head of Business' THEN 2
WHEN `split_detail` = 'key management personnel(KMP)' THEN 3
WHEN `split_detail` = 'Other Executives/general managers' THEN 4
WHEN `split_detail` = 'Senior Managers' THEN 5
WHEN `split_detail` = 'Other managers' THEN 6
ELSE 7 END

ColemenWilson

1

Re: Creating Card filters on values currently absent from a dataset

You could configure a beast mode to return the opposite and then do a NOT IN

CASE WHEN Target Go-Live Date` IS NULL THEN 'Blank' ELSE 'Not-Blank' END

Alternatively if you're wanting to do that exact value then set the Blank value for when it's populated. Do your filtering then change your beast mode back.

GrantSmith

2