Hi,
I am making a dashboard for a call center. They record things like hold time, call length...lots of time values that have nothing to do with dates.
I am trying to chart the average call lengths by week for this year versus last year. I am not having any success finding a way to handle this on my own or in the DOJO.
I have a table:
Week Number | 2018 Avg Call Length | 2019 Avg Call Length| Difference
I need to see the years as two lines in a graph as minutes and seconds, with week number as the X Axis and call time as the Y Axis. I also need to see a bar graph of the difference as minutes and seconds.
Based on my efforts, it appears as if DOMO does not like to visualize time in this way.
How can I make this happen?