Adding an average bar to chart

user060355

I have the following chart and I'd like to add a dynamic average bar that would change for each value on the x-axis. In other words, this "average" would be plotted for each month and should change with each month such that it represents the average of all values for that given month. The result should not be constant across all months.

Is this doable?

jaeW_at_Onyx

Append the dataset onto itself and replace the 'country' with 'Average'.

Write a beast mode,

case when country = 'average' then avg(amount) else sum(amount) end

jaeW_at_Onyx

Append the dataset onto itself and replace the 'country' with 'Average'.

Write a beast mode,

case when country = 'average' then avg(amount) else sum(amount) end

user060355

What do you mean by "append the dataset onto itself"?

GrantSmith

@user060355

@jaeW_at_Onyx is suggesting you take your data, replace the country column with the 'average' value, then append that back to the original dataset.

It'll look something like this:

Then you can utilize his beast mode to plot the average instead of the sum for the average amount.

user060355

@GrantSmith @jaeW_at_Onyx

Genius! Mind blown :)

Thank you!