Forum Discussion

prabhatnath's avatar
prabhatnath
Icon for Advocate III rankAdvocate 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, MitigatedD...
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.

PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

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's avatar
    prabhatnath
    Icon for Advocate III rankAdvocate 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.