Displaying Time in hours:Minutes:Seconds in Calendar

MReznick

We track out contract processing time in seconds.  I far as I can tell the only way to display the time in a calendar, Average Time per day for all locations is in seconds.  

 

 

We want it to display as '0:07:52'

 

Any advice will be helpful. 

nalbright

Have you checked the idea exchange to see whether that idea has been suggested yet?  I seem to remember this coming up before:

http://dojo.domo.com/t5/Ideas-How-would-you-make-Domo/idb-p/Ideas

McSQL

There is a beast mode that converts a number to the format: sec_to_time(AVG(`columnname`)). This could be used in a table card to show the exact time component.

 

Unfortunately, I think you may lose your color differences if you use this in the card, because it may not be able to compare the resulting values.

 

Another possible view would be a simple line or bar chart that is graphed by day. This would show the differences day by day and would give an easier view into variation day by day. Is there a specific reason you need to use the calendar view and not another chart type?

MReznick

Unfortunately, that does not work.

 

 

quinnj

Matthew, you may need to create/change the beast mode and then save the card. Sometimes when changing a beast mode, the actual results are not shown until the card is saved.

nalbright

Sadness

quinnj

Ok, I actually just tested this out for myself. It looks like we need to put the "Average Time" column as the "Event Name" and *not* put a column in for the "Event Value". I then saved the card and I'm able to see the time format for each day.

MReznick

 still not what we are looking for 

quinnj

Unfortunately, it doesn't display the event name text on the page level. If you click on the card to see the card details, you'll be able to see the time-formatted values.

MReznick

No it does not does not display it on the card view or the list view 

quinnj

Can you share a screenshot of the card view? That's where I can see the time-formatted values on each day.

nalbright

Could you share a screenshot of what you see in those views?

kshah008

@MReznick, can you provide the above information so the team can beter assist you? Thanks!