Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Average by cluster on bar chart

Is there a way to show an average of each cluster on a bar chart instead of just an average of the whole chart? I have five years of data, clustered by month. That is, there are twelve clusters, one ...
Need Help
dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous , 

I am not clear about your requirement, did you want to calculate average value of months for five years(such as show 12 months in axis, Jan will be the average of Jan in five years)? Or other logic? If possible, could you please explain in details or inform me your simple sample and expected output?

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
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.