Forum Discussion

anaxha's avatar
anaxha
Frequent Visitor
2 years ago

Status based on aggregation

Hi everyone!

I have a problem with some measure. I have a data that looks like it and I have filters in my report based on Country & Location.

So if for country DE at least one of statuses is open (for the same FileID) that means it's open, the same for location. 

How to count how many open files I have for country & location based on logic above?

I have overall score (for all countries and locations) and I want to filter it on slicers. So if I choose DE it should show me that I have 1 file closed (right now it's showing that 1 is open and 1 is closed, but it's the same FileID).

Need Help

3 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    2 years ago

    so are you saying you want it to show only one row, and show it as open even if there is one status closed for that file id / country?

     

    gpo

    • anaxha's avatar
      anaxha
      Frequent Visitor
      2 years ago

      Yes, in that case within the same fileID when I choose on the slicer country DE I want it to show 1 open and 0 closed, but when I choose location MA-1 I also want to see 1 open and 0 closed. But of course I have many more fileID's

      • vanessafvg's avatar
        vanessafvg
        Community Champion
        2 years ago

        sorry i am actually not 100% clear on the answer you want, open or closed? 

         

        it is easier if you with the above in mind can you give an example of what you want to see for each row so i can understand all the scenarios with your expected answer, also provide data in text format. 

         

        thanks