Smartsheet Chart Date Axis Formatting
I am trying to create a line chart with dates along the x-axis. The underlying smartsheet data has dates for everyday throughout the year, and when it gets pulled into a line chart the dates are all smushed together (presumably because there are alot of dates).
When I pull in a smaller subset of data limited to only a handful of dates, the dates along the x-axis appear fine:
Ideally, I would only want the x-axis to show the first date of each month (4/1, 5/1, 6/1) while keeping the underlying data in the smart sheet unchanged (the data source will still have dates for each individual day but the axis would be monthly).
Can smartsheet support something like this? I've looked at all the options in the chart widget toolbox but cannot find anything.