Forum Discussion

AmineGatou's avatar
AmineGatou
Frequent Visitor
4 years ago

Filter Card using Categorical measures

Hey everyone, I've been stuck on this problem for quite a while now.

I have created a table named "KPI" containing these values. ( These values are the expected result of a certain measure)

So that I can filter my data using it.

As you can see here, The table is filtered no problem, but the cards are not! For example the " Nb Client Sur N" count the number of clients. But it still returns the whole count of the data and not 3 ( in this example) 

Any idea how to achieve that?

Need Help
Show and Tell
Tips and Tricks

4 Replies

  • Arul's avatar
    Arul
    Super User
    4 years ago

    Hi AmineGatou ,

     

    Do you have relationship enabled between the client data table and KPI table?

     

    Thanks,

    -Arul

    • AmineGatou's avatar
      AmineGatou
      Frequent Visitor
      4 years ago

      Hi arul, no there is no relationship beetween them , since the KPI table only have two columns the KPI'S one has values that are expected to be returned from a measure ( Find it below)

       

      DiagArticleCA N/N-1 = if(and([LYTotCA]<=0,[TotCA]>0),"NEW",if(and([LYTotCA]>0,[TotCA]<=0),"LOST",if(and(and([LYTotCA]>0,[TotCA]>0),([LYTotCA]>[TotCA])),"DEC",if(and(and([LYTotCA]>0,[TotCA]>0),([LYTotCA]<[TotCA])),"INC","STB"))))

       

      I'm really stuck on this.

      • Arul's avatar
        Arul
        Super User
        4 years ago

        Hi AmineGatou ,

         

        Please ellaborate your expectation more in detail. So that i can try to figure out a way to help.

         

        Thanks,

        Arul