Help on Creating Tickets Created vs Tickets Closed by Weekday

[prabhatnath]

Hi Friends,

Need a help on a Line Chart to show Tickets created and Closed by Weekday.

I have a DataSet Tickets with columns: ID, CreatedDate, Type, Sev, Status, Title,  ResolvedDate, MitigatedDate

And a Calendar Table with Date, other columns plus Weekday (Sun, Mon, Tue....)

Something like this done was done in Excel:

Status will store: ACTIVE, RESOLVED, MITIGATED.
We can consider both Resolved + Mitigated as Closed.

Please suggest.

Thanks,

Prabhat

[v-weiyan1-msft · Accepted solution]

Hi @prabhatnath ,

Based on your description,
you might consider using the following code to create two Measures.
My Sample:
Table-Tickets:

Table-Calendar:

Created Tickets = COUNT(Tickets[ID])

Closed Tickets =
COUNTX (
    FILTER (
        'Tickets',
        'Tickets'[Status] = "RESOLVED"
            || 'Tickets'[Status] = "MITIGATED"
    ),
    'Tickets'[ID]
)

Result is as below.

Is this the result you expect?
For further details, please find attachment.

Best Regards,
Yulia Yan

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

[PijushRoy]

Hi @prabhatnath 

Please create a calculated column

Calculated Status =
If('table'[Status] IN {"Resolved","Mitigated"},"Closed Ticket","Created Ticket")

Bring the new column in visual

If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.

Thanks
Pijush
www.MyAccountingTricks.com 
https://www.youtube.com/MyAccountingTricks

[prabhatnath]

Thanks for your suggestion Pijush, but I will need 2 values (Created count for the Date) and Resolved/Closed count for the Date in Y Axis for each Day/Date.