-
Remove decimal from time format
Team, I have a very simple calculation to get time since the last record up to today's current time: CURRENT_TIMESTAMP() - MAX(`sys_created_on`) This seems to work fine and returns a time formatted like this for example: 2 02:34:26.0000 How do i modify my formula to remove the ".0000" part? Thanks Tim
-
Calculate time between incidents
Team, I am a newbie, thanks for helping I have data in a table that contains a timestamp of incident creation time on each row. I am trying to show the average time between occurrences. Basically, I want to write a calculation that with give me the average time that have passed since the previous occurrence (row) I know…
-
Averages over 5, 10, 30 days
Hey Team, I am new to DOMO so I hope this may be something easier than i have figured out. I want to create a line(?) chart that counts the items in one column (with an associated date field) and then provides me a moving average of those counts over the past 5 days, 10 days, and 30 days. for example: over the past 30 days…
-
grouped bar from extracted text
All, I Have data in a column that looks like this: California, Nevada Nevada New Mexico Colorado, New Mexico, Nevada New Mexico, Florida etc..... The column might have just one name or as many a 6 different state names separated by commas, not in any specific order. I want to make a Grouped Bar card that will count the…
-
newbie - Simple beast mode calc not showing in Summary number
Newbie here... I am simply trying to divide a field by a number to convert total seconds into Hours: `calendar_duration`/3600 Calendar_duration is a number. The calculation works but does not show as in the summary number section. Must be simple syntax to fix this. Sorry I am new to SQL code Thanks,
