Why isn't this plotting on a chart like I expect?

• junksql

  Grasshopper

  Points: 11

  More actions

  December 23, 2013 at 9:25 am

  #287635

  Good day, I'm having an understanding issue with the Chart. Here is a sample dataset:

  SELECT 'test1' AS name, 100 AS value, '12/16/2013 10:10' AS logdatetime

  UNION ALL

  SELECT 'test2' AS name, 200 AS value, '12/16/2013 10:12' AS logdatetime

  UNION ALL

  SELECT 'test3' AS name, 300 AS value, '12/16/2013 10:14' AS logdatetime

  UNION ALL

  SELECT 'test1' AS name, 200 AS value, '12/17/2013 9:05' AS logdatetime

  UNION ALL

  SELECT 'test2' AS name, 300 AS value, '12/17/2013 9:07' AS logdatetime

  UNION ALL

  SELECT 'test3' AS name, 400 AS value, '12/17/2013 9:09' AS logdatetime

  I have attached two pictures. One of them is of the design, and the other is of it being rendered. Why don't all three series' lines render on the chart? Did I set up values, categories, and series of the chart incorrectly?

  

  I'm basically just looking to chart each of the "test" values as a line separately, and their values as the x-axis, and the datetime as the y-axis. What am I doing wrong and why is nothing actually being charted and displayed?

  

  Thank you in advance!

• ndiro

  SSC Eights!

  Points: 892

  More actions

  December 23, 2013 at 10:07 am

  #1675648

  You have a problem with category Axis. Change Group Expression from longDateTime to this one:

  =DateSerial(Year(Fields!logdatetime.Value),

  Month(Fields!logdatetime.Value),

  Day(Fields!logdatetime.Value))

  It will work