1. 

   shem, Member

   The following works for displaying the '2D Stacked Bar'.
   It shows for each Dealer, a stacked segment for each `Lateness Category` and the size of the segment is the corresponding `Lateness Count`

   My question is if when hovering over a segment I wanted to not only display the `Lateness Count` but also the `Lateness Balance`, how would I do that?

       SELECT 'dbr.chart', 'StackedBar', '2D Stacked Bar', '1200', @totalHeight;
   
         SELECT `Dealer`,
   
                `Lateness Category`,
   
                SUM(`Lateness Count`),
   
                SUM(`Lateness Balance`)
   
           FROM tmp_table_delinquency
   
         GROUP BY `Dealer`, `Lateness Category`
   
         ORDER BY `Dealer`;
2. 

   myDBR Team, Key Master

   You can use the chart option tooltip and use the ColumnReferences:

   SELECT 'dbr.chart', 'StackedBar', '2D Stacked Bar', '1200', @totalHeight;
   
   SELECT 'dbr.chart.options', 'tooltip', 'Count [lc], Balance [lb]
   [dealer] / [category]';
   
   SELECT `Dealer` AS 'dealer, `Lateness Category` AS 'category', SUM(`Lateness Count`) AS 'lc', SUM(`Lateness Balance`) AS 'lb'
   
   FROM tmp_table_delinquency
   
   GROUP BY `Dealer`, `Lateness Category`
   
   ORDER BY `Dealer`;
   
   

   --
   myDBR Team
3. 

   shem, Member

   Thank you very much

Reply

You must log in to post.