Skip to main content

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!

 

If you are using it in a table maybe the value is getting grouped by other columns... try using a constant() function for the same.

 

PS: constant() will only work with PU_FUNCTIONS


Thanks for the reply, but it's not in a table, it's a number with its own formula (that is exactly the same that I copy and paste in the variable)


Reply