In the analysis I've a kpi related to a 90th quantile that displays a value = 19.01, some filters are applied. Without any filter, the value is 19.49.
Since I need to compare every instance in a table with that value, I stored it in a static value variable, that for some reasons shows the value 18.70. Another strange thing is that if I enter the code editor of the variable, the value displayed is 19.49, so coherent with the not filtered one in the analysis.
Why it show me 18.70 outside the editor? And how I can apply the same filters on the variable in order to show the correct value of 19.01? (using case when condition met then compute quantile does not work, since there is the aggregation function error).
Thanks!