Compute the percentage of a field based on two panels in the dashboard

Follow

Jellou Mae Infante

• December 27, 2022 08:48

Hi,

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!

0

• Official comment

  

  Graham Watts

  • January 02, 2023 23:51

  Hi Jellou,
  
  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 pct

  Comment actions Permalink

Please sign in to leave a comment.