I have some basic data produced weekly.
I want to do a time series chart to show change over time but it puts every day of the week in the graph.
I do not want to look at ISO week numbers as my business has different week numbers so that will be confusing (our week 33 is ISO wk24) but is there a way to create a graph just showing dates I have in my data
@mbarnes106
you can try to achieve it changing time series chart to standard column chart and this should allow you to filter out data.
Hi there,
By default you should be seeing the dates that come from the data source, Did your data have those dates with empty or 0 values? what is your data source?
You can use a filter to get rid of that date range but you may need a more dynamic solution in the future that's why I am asking you about your data source.
I only have Monday dates in my data which is why I am stuck at how to remove them. No other dates exist in the data