5 Replies Latest reply on Sep 13, 2013 6:52 AM by Joshua Milligan

    Is there a way to mask the data shown in a table post aggregation?

    daniel tibble

      For data protection reasons, I need a way of masking data displayed in a table if it is below a certain value, so if the cell value is less than 5, it needs to show '<5', and for all other cells the aggregated value.

       

      Because the output is a mixture of string and integer, I cannot get the calculated field to work properly.

       

      I know I can use Bins, but would prefer to show actuals unless it is <5

      The code I am using in the calculated field is:

       

      if countd([ID]) < 5 then '<5' else str(countd([ID]) ) end

       

      Thanks,