Forum Discussion
Solved
Percentage Compliance
I have a number value column and need to figure out how to show how many of these values are at 720 or below. How do I figure out the percentage of values that are 720 or below? Also what would be the best visualization to display the amount of values below 720?
hi Hgsilva ,
try to plot a guage visual with a measure like:
Pct =
DIVIDE(
COUNTROWS(
FILTER(
data,
data[value]<=720
)
),
COUNTROWS(data)
)
more about guage visual:
