-
1. Re: How do I generate multiple values from a single data point?
Aaron Clancy Feb 6, 2014 3:47 PM (in response to Chris Longfield)Let me know if this works for your need. I know your data will be different than mine but this is just to show you how to make something from nothing with date padding.
My Data only has 1 record in it: (The UNION I describe below is the second record)
I add a UNION to the bottom of my query that adds an "End Date" record to the data that the user can select. through Parameter passing. With "Show Empty Columns" turned on, Tableau will fill in the dates between then so table calcs will work throughout these positions.
Like I said not sure if this fully applies to your particular problem.
-
Generate Bars from 1 value.twbx 10.6 KB
-
-
2. Re: How do I generate multiple values from a single data point?
Aaron Clancy Feb 6, 2014 6:45 PM (in response to Aaron Clancy)-
Generate Bars from 1 value.twbx 11.0 KB
-
-
3. Re: How do I generate multiple values from a single data point?
Chris Longfield Feb 19, 2014 11:22 AM (in response to Aaron Clancy)So that was interesting and I did not notice the info about the union until I was debugging my version. Somehow the union does not seem to work with joined data sources.
Setting that end bucket (via the join, or however) is still a little annoying. It would be great to be able to have these "burn downs" operate on any sum you had defined - split on different dimensions, perhaps. Think milestones of a project for example.
Is this really a use case for an ETL tool like Alteryx? It seems that in the forecasting, you want to be able to manipulate the underlying data based on variables the user can control (the rate of burndown), where Tableau really wants to show you what the underlying data *is*, not what it might be if you do X.