Best Of
Re: How can I add to a dataset previously created using the DOMO Python SDK?
If you pass in the existing dataset ID it will update that dataset, otherwise if it's not included or None is passed in it'll create a new dataset.
Re: How to track video metrics in Doc Card?
The activity log doesn't capture if someone plays the video, only if they look at the doc card details as a view. I think this would be beneficial to know and I'd recommend logging a new Idea in the Idea Exchange.
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.
Is there an AI that analyses the data?
I've some data from Google ads like costs and CPA segmented by month.
Is there a way that DOMO/AI tells me any trends or breaks in trends or any other things that are worth highlighting?
Now I have to analyse the data myself but I'm sure AI could assist with this.
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.
