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?

   1.SELECT 'dbr.chart', 'StackedBar', '2D Stacked Bar', '1200', @totalHeight;

   2.  SELECT `Dealer`,

   3.         `Lateness Category`,

   4.         SUM(`Lateness Count`),

   5.         SUM(`Lateness Balance`)

   6.    FROM tmp_table_delinquency

   7.  GROUP BY `Dealer`, `Lateness Category`

   8.  ORDER BY `Dealer`;
2. 

   myDBR Team, Key Master

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

   1.SELECT 'dbr.chart', 'StackedBar', '2D Stacked Bar', '1200', @totalHeight;

   2.SELECT 'dbr.chart.options', 'tooltip', 'Count [lc], Balance [lb][dealer] / [category]';

   3. 

   4.SELECT `Dealer` AS 'dealer, `Lateness Category` AS 'category', SUM(`Lateness Count`) AS 'lc', SUM(`Lateness Balance`) AS 'lb'

   5.FROM tmp_table_delinquency

   6.GROUP BY `Dealer`, `Lateness Category`

   7.ORDER BY `Dealer`;

   --
   myDBR Team
3. 

   shem, Member

   Thank you very much

Reply

You must log in to post.