Count of orders based on an unusual day time

[Anonymous]

Hi,

I would like to calculate the number of order based on a day that starts at 5:30 pm and finishes in 24 hours, i.e. before 5:30 pm. 

My results I would like to represent as a clustered column chart. Also, I would like to preserve a Drill Down/Up option.

How feasible is it?

[v-juanli-msft]

Hi @Anonymous 

"starts at 5:30 pm and finishes in 24 hours",

For this requirement,

(case1)do you mean an order which starts from 5:30 pm and finishes before 5:30 pm +24 hours?

(case2)Or orders which are in this period 5:30 pm~5:30 pm +24 hours?

If it is case 1, how we define the order is finished? do you have a column with status in dataset?

If so, please share some example data for analysis.

if it is case 2, do you want that count for  that period all days or a certain day by selected slicer?

In addition, i don't know why it needs  Drill Down/Up option in a clustered column chart, 

Could you show example of that visual (which column should the Axis and Yaxis, Value fields be)?

Best Regards
Maggie