End of Selected Period Value

[roeibenishti]

Hi,

I have a customer service table that dates are spread through their open time:

Ticket No	Date	Ticket Closed on this Day	Ticket was opened on this day
111	01/01/2022		1
111	02/01/2022
111	03/01/2022	1
222	02/01/2022		1
222	03/01/2022

The users have dynamic report and want to have the ability to see the number of open tickets on any selection they will do.
i.e. if they will select a month dimension they will see
Jan 100 (Represent the open tickets on the 31/01/2022)
Feb 200 (Represent the open tickets on the 28/02/2022)
Mar 50 (Represent the open tickets on the 31/03/2022)

Just like selecting months they can select dates, years or even ticket number.
Any idea for this complicated issue?

[Bill_Britt]

Hi,

Take a look at this video on creating a Master Calendar. I think this is what you are looking for.

https://youtu.be/ek_ITfvCnHw

Bill

[roeibenishti]

Hi,

I already have master calendar in the model.
The problem is how to present the same ticket of dynamic report as motioned above.

I don't know which selection the user can do and I cannot aggr for 100 dimensions

The users have dynamic report and want to have the ability to see the number of open tickets on any selection they will do.
i.e. if they will select a month dimension they will see
Jan 100 (Represent the open tickets on the 31/01/2022)
Feb 200 (Represent the open tickets on the 28/02/2022)
Mar 50 (Represent the open tickets on the 31/03/2022)

If they will select days dimension they will see number of tickets that were not closed by the end of the day.

Roei