Ken beat me to it, and is spot on. My first tool to grab in a case like this is Alteryx, but Tableau can handle it just fine as Ken states, or you should be able to run it through Tableau Prep, I believe.
it looks like your data is also some kind of running total - i.e. aggregated data
the usual response is to pivot the data - and to put a real date in the data - that way you can leverage the capability to tableau date functions, trending capability and just the ability to plot a time series
If you haven't already found it Tableau has excellent on-line free training at Tableau Training: View Training Courses
it is categorized from getting stated through advanced calculations the include 3-5 minutes specific topic segments
Can you upload a sample .twbx please ? My initial thoughts are if you pivot the data in the data source tab, then change your date pivot into a date field this should work.
Will have to resolve the non-date titles such as 'before new year' but we can magick something up by using a duplicate of the date field as the title (string), but use the original date field on the x axis (date).
Hi everyone, thanks for all your quick responses. Outside of pivoting, is there another way of doing this? The way the data source is set up is a mess and it uses multiple other columns which relate to the same fields as those dates. It is for this reason that I am assuming the pivot option is not available?
My first thought was to use tableau prep but since this is connected to smartsheets, that was not an option.
We'd probably need to see a sample of the file in order to give you further advice.