Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

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