Adding an average bar to chart

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?

Best Answer

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤
    Accepted Answer

    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