Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, Im new in this
I have an excel in this way:
ID | Test1 | Test2 |
123 | Positive | |
456 | Negative | |
789 | Negative | |
147 | Positive | |
258 | Positive | |
369 | Negative | |
987 | Positive | |
654 | Positive |
And I want to use a #KPI graphic with the results of only the sum of positive of both columns (test1 and test2)
Example result: 5 positive
In the Edit expression im using this expression and of course only count 1 column but I need both columns
Edit expression
Any idea how to resolve this?
Thanks
Thank you, it worked
Please like and mark the post as the correct answer.
Hi,
You can try this.
Count({<Test1 = {"Positive"}>+<Test2 = {"Positive"}>}ID)
Thank you, it worked
Please like and mark the post as the correct answer.