1 Reply Latest reply: Feb 23, 2015 9:00 AM by Manish Kachhia RSS

    Filter based on the result of expression

    Guilherme Mota

      Hello dear!

       

      I am looking to apply a filter based on values resulting from the following constant expression in a graph :

       

      Sum ( { < Moment = {' Held '} >} [ Qt . BDA ] ) / Sum ( { < Moment = {' PLANNED '} >} AGGR ( distinct SUM ( DISTINCT [ Qt . BDA ] ) , Chv_Mom_Prod_Mês_Colab ) )

       

      This expression will return percentages for each dimension. I would like to create a filter based on percentage , which , for example, by clicking the green button seep results that were > = 100 % ; clicking yellow values between 80 % and 99 % and clicking the red values below 80 % .

       

      Sorry for my bad english and i thank the help.