4 Replies Latest reply: Aug 24, 2012 9:09 AM by Rebecca Camper RSS

Help in Bar chart

anil.chekelam

Hi,

 

    I have several grouping categories that i have to display in several types of barcharts i.e. vehcile sales comparisons                     

   

    chart1: Vvwagen Group  vs Industry Comparison

     Here i wanted to compare all Vvwagen Group brands with Industry avg   for this i was trying with this expression in dimension

   =if(match(Make,'SKDA','AUD','VVWAGEN','UGATI','SET') and GROUP1='Industry Avg',GROUP1)

    Here am trying to combine two dimensions but am not able to implement it. How can we combine two dimensions as one dimension.

     so guys requesting your help on this.

 

    chart2: Vvwagen Group Group to OEM grouping; Europe, Asian, Korean

     Here i wanted to compare Vvwagen Group with all Europe, Asian, Korean brands

  

     please find the attached sample chart type and  excel for vehcile catagories.


 

 

Regards,

Anil

  • Re: Help in Bar chart
    Rebecca Camper

    I couldn't find a way to combine the dimensions within the graph itself, but a cheat would be to include it in the script with a 'Flag'. Admittedly, this would be a hassle, as you would have to include a set analysis for calculating based upon only the 'True Data' in all your other tables/graphs, but it may be something to consider.

     

     

    Hope it helps!

    • Re: Help in Bar chart
      anil.chekelam

        thnx for your replay..it is bit confusing for me let me try it out and what 'True Data' here. could you please explain it.

    • Re: Help in Bar chart
      anil.chekelam

        thnx for your replay..it is bit confusing for me let me try it out and what 'True Data' here. could you please explain it.

      • Re: Help in Bar chart
        Rebecca Camper

        What you are essentially doing is loading the data you want to see from the 'GROUP1' field in to the 'MAKE' field, so that you are using the same dimension in your graphs. However, in order to avoid counting the data twice, you would need a way to identify what is your real data ('True Data') and what is just in there for graphing purposes. This is where that 'Flag' field comes in. Then, for example, if you want to sum your total volume you would have to use sum({$<Flag={'True Data'}>}Volume) instead of just sum(Volume) or you would be counting the placeholders.