Forum Discussion
How to provide average of column data in Card visualisation
Hello,
I'm trying to include a Card visualisation in my dashboard that simply provides the average of a single column of data (see link below). I haven't come across anything that outlines this. Can someone please help me?
Thanks and Regards,
JH
https://drive.google.com/file/d/12J9sJQ15hyjEGN98TrO_rEW4TAd4oRFc/view?usp=sharing
Hi JGH1 ,
If I understand correctly, you would like to get a average of the field [slump]. If yes, you can apply the field [SLUMP] on the visual with the aggregation function "Average" as below screenshot:
Or you can create a measure as below to get it, please find the details in the attachment.
Average of slump = AVERAGE('Sheet1'[SLUMP])If the above one is not what you want, please provide more details(special examples, screenshot etc.) to explain your expected result. Thank you.
Best Regards
1 Reply
Hi JGH1 ,
If I understand correctly, you would like to get a average of the field [slump]. If yes, you can apply the field [SLUMP] on the visual with the aggregation function "Average" as below screenshot:
Or you can create a measure as below to get it, please find the details in the attachment.
Average of slump = AVERAGE('Sheet1'[SLUMP])If the above one is not what you want, please provide more details(special examples, screenshot etc.) to explain your expected result. Thank you.
Best Regards