Card - Showing total Support Tickets at the start of the period

[FJH2024]

Hi all,

Hoping someone might have an idea if this is possible or not!

I'm working on a Support Desk Dashboard and have created these Cards:

Slicer applied to page - Date range between 05/02/2024-11/02/2024

Current Open Tickets - This is seperate to the slicers applied

Tickets Opened in Range - of the 26 Current Open Tickets, 23 of these have been opened within the date range in the slicer

Tickets Still Open in Range - of the 23 Tickets Opened in Range, 4 of these are still open

Tickets Closed in Range - of the 23 Tickets Opened in Range, 19 of these have been closed

(All of this info has been pulled from Jira)

We started the week with a total of 47 tickets (24 closed + 26 currently open) and I would like the Card on the far right to show this figure, however I'm struggling to find the correct formula to populate this here.

Does anyone know if this is even possible? This is the formula that I'm currently using for some of these cards (with some slight differences between the tables/columns they're looking at etc):

Closed Tickets = 
CALCULATE(
	COUNTA('Issues (2)'[ISSUE_STATUS_NAME]),
	'Issues (2)'[ISSUE_STATUS_ID] IN {5, 6, 10007, 10014, 10027, 10092, 10113, 10134, 10153, 10164, 10181, 10184, 10235, 10011}
)

Cumulative Closed Tickets = 
CALCULATE(
    [Closed Tickets],
    FILTER(
        ALL('Date'[Date]),
        'Date'[Date] <= MAX('Date'[Date]
        )
    ))

Total Tickets = 
COUNTROWS(
    'Issues (2)'
)

Cumulative Total Tickets = 
CALCULATE(
    [Total Tickets],
    FILTER(
        ALL('Date'[Date]),
        'Date'[Date] <= MAX('Date'[Date]
        )
    ))

Does this need to be tweaked?

I hope I've been able to explain myself well enough! Thanks so much for any help in advance 🙂

[v-xiandat-msft]

Hi @FJH2024 ,

You have currently calculated [Cumulative Closed Tickets], then also calculate the open tickets.

Subsequently, we add the two to get the number on the right card. Thank you

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.