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

    Creating a custom filter base on Number and Percentage

    gilgeraldgonong0 Aug 6, 2012 7:24 PM

      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.

      • 38 Views
      • Categories: Actions & Filters, Formatting & Display
      • Tags:
        • 1. Re: Creating a custom filter base on Number and Percentage
          Tracy Rodgers
          Tracy Rodgers Employee Aug 7, 2012 4:45 PM (in response to gilgeraldgonong0)

          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))

          end

           

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

           

          Hope this helps!

           

          -Tracy