# Show average in graph

**URL:** <https://community.glideapps.com/t/show-average-in-graph/74476>\
**Category:** Ask for Help\
**Created:** [June 29, 2024, 3:50pm UTC](https://community.glideapps.com/t/show-average-in-graph/74476 "2024-06-29T15:50:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ravikiran\_Sm](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ravikiran_sm/32/77075_2.png) [@Ravikiran\_Sm](https://community.glideapps.com/u/Ravikiran_Sm)\
**Post date:** [June 29, 2024, 3:50pm UTC](https://community.glideapps.com/t/show-average-in-graph/74476/1 "2024-06-29T15:50:50Z")

</div>

Hello fellow gliders,

I need some help here:  
My dataset looks something like this:

asset equipment average\_consumption  
ABC 123 24  
ABC 345 67  
CDE 678 89

I am trying to plot the graph with graph for average consumption of asset and equipment with asset and equipment filters. And assets can have multiple equipment. But the asset always adds up the averages in the graph. Is there a way to show values with averages when asset is selected?

Thank you !

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 30, 2024, 12:40am UTC](https://community.glideapps.com/t/show-average-in-graph/74476/2 "2024-06-30T00:40:41Z")

</div>

So you want a graph that show all assets, with their average consumption over all types of equipments?

If that’s the case, you can:

- Add a rowID column.
- Add a relation from the asset column to itself, make it a multiple match.
- Add a rollup column over the relation above, get the average value out of average\_consumption.
- Add a single value column and get the first rowID from the relation.
- In your chart, point to the table, filter by rowID is first rowID from the relation (so we get a unique row for each asset), show the average from the rollup.