Forum Discussion

rajulshah's avatar
rajulshah
Icon for Resident Rockstar rankResident Rockstar
7 years ago
Solved

Plot Minimum, Maximum, Average and Total in a chart

I need to analyze monthly attendance of students for a school. I want to know minimum, maximum and average attendance along with the total attendance. Please suggest me which visual will be better to show all these 4 values together.

 

Thanks in advance.

General Comment
Interesting Links
  • MatejZukovic's avatar
    MatejZukovic
    7 years ago

    Hi rajulshah ,

     

    I think clustered column chart could work. You may show dates as your axis, daily attendance as value and use analytics pane to bring in Min, Max & Average Line. 

     

    Best,

    Matej

2 Replies

  • MatejZukovic's avatar
    MatejZukovic
    Icon for Resolver I rankResolver I
    7 years ago

    Hi rajulshah ,

     

    I think clustered column chart could work. You may show dates as your axis, daily attendance as value and use analytics pane to bring in Min, Max & Average Line. 

     

    Best,

    Matej

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Since you need totals as well, why don't you create seperate measures for each aggregate and then use those in any visual you prefer and slice/dice using date dimension.