AnsweredAssumed Answered

How do you create a chart with dates?

Question asked by anothersmurf on Aug 8, 2018
Latest reply on Aug 8, 2018 by philmodjunk


I am trying to create a line graph "chart" using data from a record.

The record has two fields, each is a delimited value list. For example:

x                  y

1/2/2018     14

2/7/2018     17

8/1/2018     90

 

The problem is, the points of the x-axis (the dates) are evenly spaced rather than being appropriately spaced. Or with the example data, 2/7/2018 is precisely in-between the other two dates, rather than being much closer to 1/2/2018.

 

The y axis, on the other hand, is spaced correctly. 14 and 17 are almost the same, and 90 is much higher.

 

How do I make it space dates in the x-axis appropriately?

Outcomes