AnsweredAssumed Answered

Metrics Not Appearing in CCC Bar Chart

Question asked by Mark Dolente on Nov 24, 2017
Latest reply on Nov 26, 2017 by Mark Dolente

Hello community,

I'm a new user of Pentaho CDE, working on my first dashboard and am trying to create a bar chart using a data set like the following (source is a MySQL database):

VendorsEst. PayoutAct. Payout
Company 1$10,000.00$8,500.00
Company 2$15,000.00$14,500.00
Company 3$100,000.00$75,000.00


Vendors should be the X axis. Est. Payout and Act. Payout should be the Y axis. I expect the chart to look like this (created in Excel):
Screen Shot 2017-11-23 at 9.36.52 PM.png

When I attempt to create a similar chart in CDE, it looks like this:
Screen Shot 2017-11-24 at 3.34.01 PM.png
This is what I see in debug mode:

Screen Shot 2017-11-24 at 3.37.19 PM.png


I've been attempting to solve this by changing various properties of the bar chart, including:

  • Crosstab Mode
  • Series In Rows
  • Category Role
  • Series Role
  • Value Role

I do not understand why the amounts are not showing in the chart. Please help. Thanks!