Time Out of Order in Pivot Table

Q&A
,
1

Hi All,

I am having a formatting issue with a pivot table that I created. The order of time is not in the correct order (ideally I want to start at 10AM and end with 4:30PM. Does anyone know who I can change this order? Or where the source of this formatting issue is coming from?

Thanks!

Pivot Table

2

You’ll need to make your appt time’s a number and sort on that.

You may or may not have a field like this already. If you don’t here are a couple options.

If you have an appt timestamp then you can make a calculated field like this.

number_of_hour : extract(‘HH’,{appt timestamp}) + (extract(‘MM’,{appt timestamp})/100)

If you don’t have a timestamp you could use your appt time. You can do a calculated field like this.

number_of_hour = parseInt(slit({appt time},‘:’,1) + (parseDecimal(slit({appt time},‘:’,2)/100)

Then go to your appt time in the field wells, click on the drop down, and go into sort options.

image
image882×567 56 KB

In the sort options you then pick your newly created calculated field. Make sure you pick average (you could have more rows for a particular time and that would affect other aggregations). Finally click ascending.

image

Let me know if that works!