4 Replies Latest reply: Dec 16, 2015 9:10 AM by Andrew Walker RSS

    Custom Dimension

    Rishi G

      - I have a Dimension which has values - {OC, FR, CFP, FC, PR, HK,............)

      - There is no value 'Joint OC / FR' (marked in RED) in the dimension.

      - I am having an expression as count(XYZ)

       

      Question:

      - Can I get a new value in the dimension 'Joint OC and FR' (it is basically the sum of OC and FR) marked as RED and also 'Others'

      *** I have tried out resident load, renaming the column values and concatenating it with the source table. But, Here the issue is that I am getting duplicate records related to OC and FR which will impact other calculations on the dashboard.

        • Re: Custom Dimension
          Sunny Talwar

          Difficult to understand what you are trying to do. May be if you are able to share a sample with your expected output, it would be much easier to help.

          • Re: Custom Dimension
            Andrew Walker

            Hi Rishi,

                                Try this as a calculated dimension in your chart. You may need to add more field values to this if there are more values of your field than are in this script.

             

            =Pick(

            match(

            FieldName,

            'OC',

            'FR',

            'CFP',

            'FC',

            'PR',

            'HK'),

             

             

            'OC / FR',

            'OC / FR',

            'CFP',

            'FC',

            'PR',

            'HK')

             

            If you want to group other field values as 'Other' add them to the Match expression and add the same number of 'Other' lines to the Pick expression that wraps it. Be careful to have the 'Other' lines in places corresponding to the values in the match statement that you want to be grouped as 'Other'.

            • Re: Custom Dimension
              Mark Little

              HI,

               

              Another option is using a expression for each bar.

              Count({<FieldName={'OC','FR'}>}FieldName)

              Count({<FieldName={'CFP',}>}FieldName)

               

              Then label how every you like

               

              //edit - Well the typo was certainly a good one!

               

              Mark