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


1 comment

  • Official comment
    Graham Watts

    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.