Compute the percentage of a field based on two panels in the dashboard
I would want to get the percentage of how the tenant is consuming from the overall. The two panels are exactly the same except that the one on the right has tenant on it. Thanks!
To get a percentage we can use the total operator then divide by the total.
Assuming we want to total up the totaltime_minutes field across all rows, then find the % that each row contributes, we can do this:
| total totaltime_minutes as total
| (totaltime_minutes/total)*100 as pct
| rond(pct,2) as pctComment actions
Please sign in to leave a comment.