Forum Discussion

prabhatnath's avatar
prabhatnath
Advocate III
2 years ago
Solved

Help on Creating Tickets Created vs Tickets Closed by Weekday

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

Need Help
  • v-weiyan1-msft's avatar
    v-weiyan1-msft
    2 years ago

    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.

3 Replies

  • v-weiyan1-msft's avatar
    v-weiyan1-msft
    Community Support
    2 years ago

    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.

    • prabhatnath's avatar
      prabhatnath
      Advocate III
      2 years ago

      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.