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.
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
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?
Unfortunately, that does not work.
still not what we are looking for
No it does not does not display it on the card view or the list view
Could you share a screenshot of what you see in those views?
@MReznick, can you provide the above information so the team can beter assist you? Thanks!