Combine year with amount on the x-axis of a stacked bar chart

Hello, I have a stacked bar graph where on the x axis I have years and as stacked graphs, quantities. I need to show on the x-axis, each bar with the “year - total”, however with a calculated field I can’t do it because I can’t use aggregation functions with non-aggregation functions. How could I do to solve it, if there is a way. Thank you


Hi @Victor

You can use PRE_AGG calculations for totals.


1 Like

Yes to build on what @Max proposed, use the sumOver() function and partition it by Year inside the square brackets, and then convert to a string with toString, then use concat() to combine into a single string value - it should let you place that on the X-axis.

1 Like