Aggregation with the dimension used in "animate"

[#1]

Good day,

I want to make a "scatter chart" with an animation.

I have the following dimension :

- abs : a value for the X axis
- ord : a value for the Y axis
- value : a value for the size of the plot
- product : I want to display the values by product
- date : I want to watch my graph for a specific date

The axis I want to use for my animation is "Date".

I want to display a reference line that displays the average "Org" and the average "Abs". My formula is

aggr(avg(Abs), Date)

When I select only 1 date, my reference line is correctly displayed :

But when I select more than 1 date, the graph doesn't know which date is the date of the current "Date" dimension (the one used for the animation) :

How can I do to use the "current" Date ? (= make an aggregation with the dimension used in the "animate")

[martin59]

Hi,

Look at the attachement, when there is several possible dates, the reference line shown datas for the dimension used in the chart.

Is that you want ?

Martin

[#3]

Thank you for your exemple, but this gives the overall average.

What I want is the average for the date used in the animated axe. As if I manually select "1", then "2", then "3", ...

[martin59]

Look at my application, it shows the average for the visible dimension when it's static.

If you animate the dimension, I think that we can't get back the "simulated selection".

Martin

[kji]

Reference lines are calculated from the overall logic state, and thus will not change during the animation, so cant be used to achieve what you want here.

[#6]

Johan Idh wrote:
Reference lines are calculated from the overall logic state, and thus will not change during the animation, so cant be used to achieve what you want here. <div></div>

OK, good to know...

Too bad for me 😞