Forum Discussion

fabio_garcia85's avatar
fabio_garcia85
Regular Visitor
5 years ago
Solved

Summarize after user filter condition

Hi!   I have a column for calculating percentage (Amount of errors divided by the amount of requests) per day. This table is one line per day. Image below:   When I show this percentage per...
  • dedelman_clng's avatar
    dedelman_clng
    5 years ago

    Hi fabio_garcia85 -

     

    Don't calculate the percentage as a column. Change it to a measure and it should give you the right answer at all levels. You can add the measure as a column to a table or matrix visual and if you are showing individual rows it will act exactly like a column.

     

    Example:

    ErrorPercentage = 
  DIVIDE(SUM(Error), SUM(Total), 0)

     

    Hope this helps

    David

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
5 years ago

Hi fabio_garcia85 -

 

Don't calculate the percentage as a column. Change it to a measure and it should give you the right answer at all levels. You can add the measure as a column to a table or matrix visual and if you are showing individual rows it will act exactly like a column.

 

Example:

ErrorPercentage = 
  DIVIDE(SUM(Error), SUM(Total), 0)

 

Hope this helps

David