number of Dots in Scatter Chart don't match number of rows in table
I have a straight table tied to an inline table which has values (all, 5, 10).
I've written a expression to read off of aninline table to only show the top 5 rows(based on rank). The expression works great - when I click on 5 - only 5 rows show.
On the same tab - I have a scatter plot - when I click 5 and my straight table reduces to 5 - I would expect my scatter plot to reduce to 5 dots as well - however, it stays the same. I've also tried adding the same expression to the chart, but it doesn't seem to help.
if I then select the 5 rows in the table, the chart then gets updated.
Is there a way to have my chart update to 5 dots when I click on the inline table?
Re: number of Dots in Scatter Chart don't match number of rows in table
The expression looked quite strange - there isn't no aggregation included within all the if-loops and most often it's better to apply those conditions only per selections.
I think you need more an approach like this Top 5 analysis using Rank fuction whereby within the most charts (unless pivot-table) you could simply use a simple expression like sum(value) and makes the top/flop settings within the options from tab restrictions.