Charts - Value over Time

Cory Griffis

I am trying to create a chart which displays a contingency fund remaining balance over time. Here is what I was able to produce:

This looks great, but the x-axis(time) is not to scale. I am pulling from a sheet that contains all instances of contingency fund draws, but they will not occur at a regular interval. Is there any way for the chart to adjust the x-axis scale based on date, so I can get a more accurate representation of the fund over time?

Genevieve P.

Hi @coryg

This chart looks great! The way you have it set up is the only way that chart widgets are able to recognize dates in the x-axis. Essentially it sees the Date Column more like a Text Column, bringing over the dates as text labels.

This means that you can't currently configure chart widgets to recognize a date column and spread out the values according to the days between. You would need to have each day/date listed in your sheet so the chart can recognize the data pulled into it.

Please submit an Enhancement Request to let our Product team know about your feature suggestion!

Cheers,

Genevieve

Genevieve P.

Hi @coryg

This chart looks great! The way you have it set up is the only way that chart widgets are able to recognize dates in the x-axis. Essentially it sees the Date Column more like a Text Column, bringing over the dates as text labels.

This means that you can't currently configure chart widgets to recognize a date column and spread out the values according to the days between. You would need to have each day/date listed in your sheet so the chart can recognize the data pulled into it.

Please submit an Enhancement Request to let our Product team know about your feature suggestion!

Cheers,

Genevieve