# Average value (annotation line) in stacked-bar chart
**URL:** https://community.fibery.io/t/average-value-annotation-line-in-stacked-bar-chart/5295
**Category:** Get Help
**Created:** [October 14, 2023, 6:46pm UTC](https://community.fibery.io/t/average-value-annotation-line-in-stacked-bar-chart/5295 "2023-10-14T18:46:52Z")
**Posts on this page:** 14
**Page:** 1
### Author:  [@Mikhail](https://community.fibery.io/u/Mikhail)
#### Post date: [October 14, 2023, 6:46pm UTC](https://community.fibery.io/t/average-value-annotation-line-in-stacked-bar-chart/5295/1 "2023-10-14T18:46:52Z")
Hi! How do I output the average value (line)?
The average should be something like this:
AVG([Expenses]) doesn’t work the way I want.
The X-axis is Date.
Thank you very much!
---
### Author:  [@Mikhail](https://community.fibery.io/u/Mikhail)
#### Post date: [October 21, 2023, 11:08am UTC](https://community.fibery.io/t/average-value-annotation-line-in-stacked-bar-chart/5295/2 "2023-10-21T11:08:09Z")
Maybe there’s an example or something similar?
---
### Author:  [@Chr1sG](https://community.fibery.io/u/Chr1sG)
#### Post date: [October 21, 2023, 5:46pm UTC](https://community.fibery.io/t/average-value-annotation-line-in-stacked-bar-chart/5295/3 "2023-10-21T17:46:54Z")
The colour coding seems to show that there are actually a lot of small values (stacked on top of each other) so I suppose that the average is correctly calculated for these values, as separated into categories.
Can you check the behaviour with the colour grouping turned off.
---
### Author:  [@Mikhail](https://community.fibery.io/u/Mikhail)
#### Post date: [October 23, 2023, 4:03pm UTC](https://community.fibery.io/t/average-value-annotation-line-in-stacked-bar-chart/5295/4 "2023-10-23T16:03:21Z")
Thank you for the reply! Unfortunately, nothing has changed
---
### Author:  [@Chr1sG](https://community.fibery.io/u/Chr1sG)
#### Post date: [October 23, 2023, 4:37pm UTC](https://community.fibery.io/t/average-value-annotation-line-in-stacked-bar-chart/5295/5 "2023-10-23T16:37:18Z")
It still looks like the bars are segmented. What is the configuration of the y-axis?
---
### Author:  [@Mikhail](https://community.fibery.io/u/Mikhail)
#### Post date: [October 23, 2023, 6:11pm UTC](https://community.fibery.io/t/average-value-annotation-line-in-stacked-bar-chart/5295/6 "2023-10-23T18:11:45Z")
@Chr1sG
---
### Author:  [@Chr1sG](https://community.fibery.io/u/Chr1sG)
#### Post date: [October 23, 2023, 6:25pm UTC](https://community.fibery.io/t/average-value-annotation-line-in-stacked-bar-chart/5295/7 "2023-10-23T18:25:24Z")
So it looks like you are plotting the value of Cymma for each entity, but then stacking them where they share the same Date (based on the date grouping of the x-axis). So the average will be the average value of Cymma for all entities, not the average value of the sum of Cymma for each date period.
What does it look like if you set the y-aggregation to ‘`Sum`’ and then set the Annotation line as `AVG(SUM([Cymma]))`
?
---
### Author:  [@Mikhail](https://community.fibery.io/u/Mikhail)
#### Post date: [October 23, 2023, 7:16pm UTC](https://community.fibery.io/t/average-value-annotation-line-in-stacked-bar-chart/5295/8 "2023-10-23T19:16:12Z")
@Chr1sG
I think that’s what I need - solution:
but the chart type is not stacked-bar, unfortunately
---
### Author:  [@Chr1sG](https://community.fibery.io/u/Chr1sG)
#### Post date: [October 23, 2023, 9:12pm UTC](https://community.fibery.io/t/average-value-annotation-line-in-stacked-bar-chart/5295/9 "2023-10-23T21:12:45Z")
Out of curiosity, what happens if you add the colouring by category back in?
---
### Author:  [@Mikhail](https://community.fibery.io/u/Mikhail)
#### Post date: [October 24, 2023, 2:30pm UTC](https://community.fibery.io/t/average-value-annotation-line-in-stacked-bar-chart/5295/10 "2023-10-24T14:30:41Z")
@Chr1sG
sadly:
---
### Author:  [@Chr1sG](https://community.fibery.io/u/Chr1sG)
#### Post date: [October 24, 2023, 2:43pm UTC](https://community.fibery.io/t/average-value-annotation-line-in-stacked-bar-chart/5295/11 "2023-10-24T14:43:00Z")
Yeah, kinda what I expected, Just wanted to check.
Does the y-axis config allow you to define the annotation line as `AVG(SUM([Cymma]))` ?
---
### Author:  [@Chr1sG](https://community.fibery.io/u/Chr1sG)
#### Post date: [October 24, 2023, 2:43pm UTC](https://community.fibery.io/t/average-value-annotation-line-in-stacked-bar-chart/5295/12 "2023-10-24T14:43:51Z")
Also, what does it look like if you choose side-by-side bars instead of stacked?
---
### Author:  [@Mikhail](https://community.fibery.io/u/Mikhail)
#### Post date: [October 24, 2023, 3:07pm UTC](https://community.fibery.io/t/average-value-annotation-line-in-stacked-bar-chart/5295/13 "2023-10-24T15:07:16Z")
> [@Chr1sG](#):
>
> Does the y-axis config allow you to define the annotation line as `AVG(SUM([Cymma]))` ?
No: Cannot use aggregation inside aggregation
> [@Chr1sG](#):
>
> side-by-side bars
I can’t find that option…
Like this?
---
### Author:  [@Chr1sG](https://community.fibery.io/u/Chr1sG)
#### Post date: [October 24, 2023, 3:52pm UTC](https://community.fibery.io/t/average-value-annotation-line-in-stacked-bar-chart/5295/14 "2023-10-24T15:52:41Z")
> [@Mikhail](#):
>
> No: Cannot use aggregation inside aggregation
Yeah, I feared that would be the case ☹
> [@Mikhail](#):
>
> Like this?
Yeah, that’s what I meant. I can see it’s rather ugly though. Might look better with fewer x-axis groups, but I’m afraid the choices you have seem to be either side-by-side, or no categorisation.