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 for each month, and five bars, one for each year, in each cluster. I'd like to show the avereage for each month. I don't see a way to do this with the standard visual, but maybe I'm looking in the wrong place. Alternatively, does anyone know of a third-part visual that would allow this?

 

Thanks!

Need Help

1 Reply

  • 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.