Currently I am making visualization using two sheets, one sheet has reporting element as group name where I used count logic. For instance, in the above picture Low Risk Members, Moderate and High Risk Members are coming from one column as reporting element.
However I am using second sheet because the denominator is different for each element so I had to use calculated field for percentage.
Now the problem is if I applied some filter, the left visual (say that filter don’t have Low Risk Member will be gone) however the right side of Low Risk Member % calculation will be still there. What I want is to remove Low Risk Member % when the left side Low Risk Member element is not available.
Hi @Santosh! I pinged one of our SAs. Wanted to let you know that this question is on our radar and we will circle back on Monday if we haven’t heard from other members of the Community before then. Thanks so much for posting your question!
Did Roys answer help you?
Alternatively, if you do need to use a separate sheet for your visual(s), you can utilize parameter based controls on the first sheet and then apply filters on both sheets using that parameter. That way, visuals on the different sheets can be filtered by the same selection.
I’ll mark this as a Solution, but please feel free to let us know if you need further assistance on this.