I have an issue creating a customer service dashboard and also watching multiple youtube tutorials didnt help me:
I have an excel sheet offering 3 columns: Ticket created (date), Ticket closed (date), Ticket status (closed, pending, in work, blank)
I created a day slicer which lets me select any kind of date range. Now my goal is to create 3 KPIs for the respective date ranges I select in the Slicer: 1. # of tickets created 2. # of tickets closed
3. # of open tickets
I already created a separate date table. Thereby, I managed to create the KPI '# of tickets created' but the other two are not possible. I guess especially the third KPI requries some calculation?
e.g.: @Greg_Deckler : I saw that you are quite familiar with the topic. Would you be so nice and could help me pleease? Would be such a help!
But I do not have another status column. Rather, I would like to count the tickets, which are created but not closed yet during the respective time range selected in the slicer. I guess it would have to be somehow dynamic? Could you help me with that? Highly appreciated! Thank you!