3 Replies Latest reply: Apr 22, 2015 7:45 AM by Gysbert Wassenaar RSS

    Creating a dimension from 4 different field names

    Ridhaa Hendricks

      Hi There

      I have 4 fields

       

      Each field has Numerical values  in them.

      I would like to create one field from the 4 and call it Age_Group.

      so that I could use this as the Dimension in a Pie chart.

            QUANTITY_3_MONTHS,
           QUANTITY_3_TO_6_MONTHS,
           QUANTITY_6_TO_12_MONTHS,
           QUANTITY_12_MONTHS_PLUS

       

      What is the simplest way to do this?

       

      Your assistance is appreciated.

      Thanks.

        • Re: Creating a dimension from 4 different field names
          Gysbert Wassenaar

          Probably a CrossTable load:

           

          CrossTable(Age_Group,Value)

          LOAD

              SomeKeyField,

               QUANTITY_3_MONTHS,

               QUANTITY_3_TO_6_MONTHS,

               QUANTITY_6_TO_12_MONTHS,

               QUANTITY_12_MONTHS_PLUS

          FROM ....

          ;

            • Re: Creating a dimension from 4 different field names
              Ridhaa Hendricks

              Hi Gysbert

               

              This is how I did it... do you think I could run into any problems doing it this way?

              I have validated the the values they seem good.

              I will try the crosstable in a bit its clearly much simpler.

               

              Load



                  
              TONS_3_MONTHS as Ton_Value,

                   'TONS_3_MONTHS'
              as AgeGroup,

                  
              AgeItemKey

                  
              Resident Daily_Stock_On_Hand;



              Concatenate    

              Load    

                   
              TONS_3_TO_6_MONTHS as Ton_Value,

                   'TONS_3_TO_6_MONTHS'
              as AgeGroup,

                  
              AgeItemKey

                  
              Resident Daily_Stock_On_Hand;



              Concatenate    

              Load



                    
              TONS_6_TO_12_MONTHS as Ton_Value,  

                      'TONS_6_TO_12_MONTHS'  
              as AgeGroup,

                    
              AgeItemKey

                      
              Resident Daily_Stock_On_Hand;

                      

              Concatenate        

              Load



                     
              TONS_12_MONTHS_PLUS as Ton_Value,  

                      'TONS_12_MONTHS_PLUS'  
              as AgeGroup,

                     
              AgeItemKey

                      
              Resident Daily_Stock_On_Hand;