Forum Discussion

MTPisaris's avatar
MTPisaris
Regular Visitor
7 years ago
Solved

Total Count per month by Status

Hi Guys,   Please i need your help urgently. I have a table with records of incidents with different status (Open, Assigned and Closed).   I will like to create a line and clusterred column char...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    MTPisaris assuming you have table name called incidents with following fields

     

    Date

    Incident Id

    Status

     

    To achieve the result your are looking for

     

    - select clustered column chart visual

    - add date on x - axis

    - add status on legend

    - add incident id on value and make sure aggregation is set to count, or write a measure like below and put that on value

     

    Incidents = COUNTROWS( TableName )
  • dax's avatar
    dax
    7 years ago

    Hi,

    Yes, you could refer to perry2k's suggestions, and use date hierarchy in axis or you could create a column for Year-month by expression :Column = YEAR(chart[date])*100+chart[date].[MonthNo], and use this in axis

    Best Regards,
    Zoe Zhi

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

     
dax's avatar
dax
Community Support
7 years ago

Hi,

Yes, you could refer to perry2k's suggestions, and use date hierarchy in axis or you could create a column for Year-month by expression :Column = YEAR(chart[date])*100+chart[date].[MonthNo], and use this in axis

Best Regards,
Zoe Zhi

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