Chart to plot the time of day we created our 45th order

[#1]

I'm after some advice & guidance on the best way to plot on a daily basis the time we achieved our 45th order. In my fact table I have the date & time ordered and can do a count(Distinct Order_No) to get the order count so just need to plot this maybe on a bar chart but happy to take any other suggestions. Has anyone attempted anything similar?

Thanks

Gavin

[Gysbert_Wassenaar]

Can you post some sample data?

[#3]

Order No	Date	Time
123	01/06/14	08.00
124	01/06/14	08.15
125	01/06/14	08.20
126	01/06/14	08.25
127	01/06/14	08.30
128	01/06/14	08.40
129	02/06/14	08.10
130	02/06/14	08.30
131	02/06/14	08.45
132	02/06/14	09.10
133	02/06/14	09.20
134	02/06/14	09.30
135	03/06/14	08.00
136	03/06/14	09.00
137	03/06/14	09.20
138	03/06/14	09.50
139	03/06/14	10.00
140	03/06/14	10.15
141	03/06/14	11.00

Thanks for your reply. If you look at the orders for each day (using 5th order of the day as an example rather than 45!) you'll see that we entered our 5th order (127) on 01/06/14 at 8.30, our 5th order (133) on 02/06/14 at 09.20 and on the 3rd (139) at 10.00. I'm almost looking for a running count = 5 type scenario.. Could I use rangesum maybe?

Thanks

[Gysbert_Wassenaar · Accepted solution]

I don't know what you want to show in a chart, but in the attached example you can find a way to give the orders for each day an index number.

[#5]

Worked a treat. Thanks for your help 🙂