2D Stacked Column - How can I display just the two stacks with totals and not sum of the two totals?

(3 posts) (2 voices)
  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`,
    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
    FROM tmp_target_collected_totals
    ORDER BY totals_category, Collector;

    myDBR Team

  3. shem, Member

    Thank you


You must log in to post.