Best Of
Re: Using Variables in Beast Mode
Here's a re-worked case statement:
CASE
WHENDate of Deathis NULL THEN FLOOR(DATEDIFF(CURRENT_DATE(),Date of Birth)/365)
WHEN FLOOR(DATEDIFF(Date of Death,Date of Birth)/365) < 1 THEN '<1'
WHEN FLOOR(DATEDIFF(Date of Death,Date of Birth)/365) < 3 THEN '1-3'
WHEN FLOOR(DATEDIFF(Date of Death,Date of Birth)/365) < 6 THEN '3-6'
WHEN FLOOR(DATEDIFF(Date of Death,Date of Birth)/365) < 9 THEN '7-9'
WHEN FLOOR(DATEDIFF(Date of Death,Date of Birth)/365) < 12 THEN '10-12'
WHEN FLOOR(DATEDIFF(Date of Death,Date of Birth)/365) < 15 THEN '13-15'
WHEN FLOOR(DATEDIFF(Date of Death,Date of Birth)/365) < 18 THEN '16-18'
ELSE '18+'
END
Due to how case statement functions, you are able to remove the between logic and just use less than logic which makes the statement a bit more concise.
Hope this helps.
Re: Unpivot and Pivot
In this case I'd join to the date dimension, find all of the days between TimeOffDate and ReturnToWork and split the HoursOff between them.
Similar to this:
Re: Multiple Values in a Pie Chart
You can also combine the Tootip Field and the datalabel settings to display multiple values. However, the Pie value will only take the first into account.
New Member to Community - Hello All!
Hello, I'm Alex Sisco, from Robert Half International. I am a fleet performance technician, and responsible for fleet automaton innovation, reporting, and management. Ill be using Domo to provide metrics of Asset Management to our management vertical.
typ211
Re: 'Prevent drilling to final data grid view' manage at dashboard level
I agree that this is needed! We often have table drills already set up in a desired format, and we don't need users to have to scroll through unnecessary columns in the data grid view if they accidentally click on a value.



