Plot Minimum, Maximum, Average and Total in a chart

[rajulshah]

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.

[Anonymous]

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.

[MatejZukovic · Accepted solution]

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