1 Reply Latest reply on Aug 7, 2012 4:45 PM by Tracy Rodgers

    Creating a custom filter base on Number and Percentage

      Hi All,


      I have a requirement that I need to create a custom filter in my Dashboard. This filter will let the user choose whether the label can be shown in Number format (0,000.00) or Percentage format (%) in all of my graphs and tables.


      Can this be done? Please provide step by step.


      Thanks in advance.

        • 1. Re: Creating a custom filter base on Number and Percentage
          Tracy Rodgers

          Hi Gil,


          This can be done by using a parameter. Create a string parameter that lists the different formats (i.e. Number, Percentage). Then, using this parameter, create a calculated field using the desired measures. (Note: the measures will need to be converted into strings so that the percentage sign can be applied). For example:


          case [Format]

          when 'Percentage' then str(round(avg(Discount)*100,2)) + "%"

          when 'Number' then str(round(avg(Discount), 3))



          Then, place this on your view. Finally, right click on the parameter and select Show Parameter Control.


          Hope this helps!