"Time of day" report

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
I have a field of type "Time of day" that captures minutes of an activity on daily basis and I would like to have a report (Line and Bar Chart) that can show the daily captured values on the line , thanks for any help.
Photo of Rani Khoury

Rani Khoury

  • 174 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,908 Points 50k badge 2x thumb
Are you looking for a graph that will show the number of transactions in for example any particular hour? I.e. the height of the bar represents the number of transactions and the series progression of the bars across the width would be the buckets for the time of day?
Photo of Rani Khoury

Rani Khoury

  • 174 Points 100 badge 2x thumb
Hello,

We have analysts that take calls on daily basis (Date field), we measure the Average Handle Time (Time of day) and the number of tickets closed by the analyst.

I am looking for a graph to show the number of tickets closed (or calls received) as bars, the AHT as a line for the daily interactions (the X axis).

I've tried to accomplish this, but seems certain field types disappear for the field drop down when I want to plot them (Time of day).

Thank you,
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,908 Points 50k badge 2x thumb
Time of day is is a field like say 10:25 am, ie when you look at our watch, what time is it.  

That is not a Duration field.  A duration field type expresses how long something took.  For example if it took 15 minutes and 20 seconds to handle a call, that is a duration.  I suspect that you are using a time of day field to hold a duration and that is why the chart is not allowing you to measure the time of day.

If this is the case and you already have a lot of data entered, then that data will need to be converted once we understand who you have been entering the data. 
(Edited)
Photo of Rani Khoury

Rani Khoury

  • 174 Points 100 badge 2x thumb
Thanks for the prompt reply.

I see, AHT is indeed a duration that is being measured for each analyst on each day.

If a call lasted 10 minutes, then it is entered as 00:10:00 (24 hours format) and the format shows only the minutes 00:10.

When you say "the chart is not allowing you to measure the time of day" you mean show it? as I am not trying to apply formulas...etc
 
Regards,
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,908 Points 50k badge 2x thumb
Please tell me the field type for the field AHT 
Photo of Rani Khoury

Rani Khoury

  • 174 Points 100 badge 2x thumb
Time Of Day
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,908 Points 50k badge 2x thumb
Right, so the time of day is not a duration field.  

It is like I said above, its the time of day like what time it is.  Right now in my time zone it is 9:24 am.

So you have an incorrect field type being used to hold a duration for how long it took to handle a call.
Photo of Rani Khoury

Rani Khoury

  • 174 Points 100 badge 2x thumb
Got it, now my question that I will have to change the type to a numerical value, right?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,908 Points 50k badge 2x thumb
First of all, if you have historical data that you do not want to use, make a copy of that field right now. That will copy the data into a new field.

You can choose to make the new field a duration field, but if the data entry is entered in minutes, then a numeric field is probably easiest to wort with.

Do you have historical data entry which needs ot be converted?
Photo of Rani Khoury

Rani Khoury

  • 174 Points 100 badge 2x thumb
I have some (~22 records) as the application is still freshly created, so I can either rework it or test with a conversion.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,908 Points 50k badge 2x thumb
OK, so you will just grid edit those 22 records to correct them.  Make a new field, probably just a numeric field called [AHT minutes]
Photo of Rani Khoury

Rani Khoury

  • 174 Points 100 badge 2x thumb
Perfect, thanks a bunch for the help!
Photo of Drew Woods

Drew Woods

  • 216 Points 100 badge 2x thumb
My question is in regards to the time of day, but not so much about the fields.

I want to run a report that shows me the number of ticket created during a specific time of day.

Our offices open at 8am and close at 8pm. But I want to know how many tickets are being created during the 8am - 10am time slot.

Is that something you can help with?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,908 Points 50k badge 2x thumb
np

Just make a new field of type formula Time of day called perhaps [Time of Day]

ToTimeOfDay([Date Created])

Then make a Summary Report and do a "Group Rows by" on hours.

Then you will get every hour, and not just 8 to 10.


I did not test, but it is highly likely that you can also make a pretty bar chart similarly.
Photo of Drew Woods

Drew Woods

  • 216 Points 100 badge 2x thumb
Ahhhhh dang. I was using the wrong kind of report. Thank you so much. This helped immensely!