I need to display a percent on my dashboard. This percent should be calculated by dividing one count measure (derived from certain filters applied) over another count measure (which does not have those same filters).
For example, I select “count” and it gives me 40 when I apply the “in the month February” filter. Without this filter, the count would be 100. I need to display 40/100 = 40% on my final dashboard.
I tried using table calculations, but since both the column names are the same, I can’t divide them with each other. Any other way to do this?