Dynamic filtering on a scatter plot

Hey,

I have e.g. the data like this:

I want to have a scatter plot that shows the filtered data spread in a sunray type of way.

X and Y values are direct input to the x and y for the scatter plot.

X = COS(RADIANS(270 - 90 *(Order / Total)

Y = SIN(RADIANS(270 - 90 * (Order / Total)

With total = 5 (i.e. the total number of rows)

And with "Order" column calculated automatically

Problem is: I want to have a filter next to the scatter plot to filter e.g. on Country  = FR. At that point, I need to have Order and Total dynamically re-calculated:

Total = 2 (as I have 2 lines left after the filtering on Country = FR)

Order needs to update as well, showing nothing in the first 3 lines and 1 and 2 in the two bottom lines.

The scatter plot needs to be updated accordingly as well, taking into account the newly calculated X and Y value.

I starting to doubt that all of this is actually possible 🙂

Thanks,

Wim