-
1. Re: Grouping Multiple fields as "dates"
Ken Flerlage Jan 28, 2019 1:24 PM (in response to Brian Bruning)I think you'll most likely want to pivot those columns to rows. See the following for details on how to do that: https://www.kenflerlage.com/2018/06/pivoting.html
-
2. Re: Grouping Multiple fields as "dates"
Gene Denny Jan 28, 2019 1:25 PM (in response to Ken Flerlage)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.
-
3. Re: Grouping Multiple fields as "dates"
Jim DehnerJan 28, 2019 1:27 PM (in response to Brian Bruning)
Hi Brian
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
Jim
-
4. Re: Grouping Multiple fields as "dates"
Peter Fakan Jan 28, 2019 1:27 PM (in response to Brian Bruning)Hi Brian,
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).
HTH
Peter
-
5. Re: Grouping Multiple fields as "dates"
Brian Bruning Jan 28, 2019 1:32 PM (in response to Brian Bruning)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.
-
6. Re: Grouping Multiple fields as "dates"
Ken Flerlage Jan 28, 2019 1:35 PM (in response to Brian Bruning)We'd probably need to see a sample of the file in order to give you further advice.