-
Re: How can I get rid of extra characters in attributes
If it is always between the first and second underscore, you can do this: SPLIT_PART(fieldname,'_',2)3 -
Re: Calculate time between incidents
I would take what @GrantSmith is suggesting, but do it in Magic ETL because it already supports the window function and you don't need to talk toy our CSM. Just use the Rank & Window tile and use…1 -
Re: Rating Card
You can make stars by doing a beast mode like this: (CASE WHEN AVG(Object_Health_Score) >= '.8' THEN ' ★★★★★' WHEN AVG(Object_Health_Score) >='.6' THEN ' ★★★★☆' WHEN AVG(Object_Health_Score) &g…3 -
Re: Where is the subtotal chart option? thanks
In the Chart Properties section, you need to select Show subtotal rows under the subtotal rows section and then the subtotal section will be enabled for each column.1 -
Re: Create a Line Chart that shows the different series while also showing the aggregate of the series?
The easiest way I have found to do this is to use the Segments feature. https://domo-support.domo.com/s/article/4403089503383?language=en_US In the columns to create a segment, select the column that…2