I take snapshots of certain values at irregular date spacing. I plot them in a line chart and each snapshot is evenly distributed across the x axis, even though some data points might be 2 months apart and others 2 days apart. This leads to a misleading/inaccurate appearance in the graph.
Can monday add an option like 'X-axis> Space dates accurately" where the X axis reflects the spacing selection (days/weeks/months) and puts the data points at the appropriate location?
For instance, the following data
Dec 12: 5
Dec 13: 6
Jan15: 7
Jan 17: 8
The way a chart currently plots the data, it will look like a perfect upward trend and perfectly straight line, but that is not an accurate visual representation of the significantly reduced increase during the Dec 13 to Jan 15 period.
This is actually the same request on another thread that asks how to also display 0 values on the x axis of a chart (thus, spacing the dates accurately). @Julietteb is there a way this can be solved?
Thanks for bringing it up! I can merge the thread so it gets more votes and can pass it on to our team as well! If you can share the similar threads I will merge them all together!
@Admeirel@Julietteb Close, but we don’t want to display 0 for those x-axis values, we want space on the x axis for the empty days. if a value must be displayed it would be some kind of mathematical interpolation.
0 would skew the line. Those days between don’t have a value, as no value was collected, but values taken 1 day apart vs 20 days apart should result in an appropriate slope.
The x-axis in monday graphs shows adjacent data points, regardless of how many days were between, instead of a true independent axis of all days sequentially with a value corresponding to only those days with data