1. 

   shem, Member

   I am displaying a StackedColumn Bar chart of type 2D Stacked Column
   As expected it displays the chart with two totals one stacked on the other with different colors, and each groups total displayed in the middle of the colored box.
   In my example The two totals are totals for each "Collector" and they represent categories named "Targeted Amount" and "Collected Amount".

   In addition, it displays a number I do not want displayed and that is the sum total of the two totals (which are displayed inside boxes) is displayed on top of the stack.
   Thus if the "Targeted Amount" total for the Collector named Bryan is 7,020 and the "Collected Amount" total for Bryan is 8,869, then you will see at the top of the stack the number 15,889.
   But I do not want 15,889 to be displayed since it has no logical meaning.

   Here is my code:
   

       select 'dbr.chart',         'StackedColumn', '2D Stacked Column';
   
       select 'dbr.chart.options', 'rotateNames', '25';
   
         SELECT `Collector`,
   
                `totals_category`,
   
                `totals`
   
           FROM tmp_target_collected_totals
   
       ORDER BY `Collector`, `totals_category`;  
2. 

   myDBR Team, Key Master

   You can omit the total summary with option:

   select 'dbr.chart.options', 'showValues', 'data';

   If the total summary of the two categories has no logical meaning, an another option for chart would be the multiseries column chart. You could do:

   select 'dbr.chart', 'MSColumn', 'Collector data';
   
   select 'dbr.chart.options', 'rotateNames', '25';
   
   SELECT
   
     totals_category,
   
     Collector,
   
     totals
   
   FROM tmp_target_collected_totals
   
   ORDER BY totals_category, Collector;

   --
   myDBR Team
3. 

   shem, Member

   Thank you

Reply

You must log in to post.