Forum Discussion
Advocate IDisplaying multiple dates across a single x axis
kenyonca You're correct, I don't think you would be able to use those filters. How about this as another option? What we need to do is unpivot your dates in the Query Editor. I added Location as a column in my sample dataset to use as an example.
In the Query Editor I selected my date columns and clicked Unpivot Columns
The result is this; you can rename "Attribute" and "Value" if you want, but now you have a list of dates that are being described by the attribute.
You can now set up a relationship between your Date table and your single Date column in your table
I can build a bar chart that looks like this:
And filter on location using a Slicer.
Does this meet all your requirements?
Advocate II am trying to display different stages of our planning on the same line and bar graph.
To simplify my data that I have pulling from SmartSheet:
Work Plan ID Draft Plan Date Design Need Date IFC Plan Start Date Actual Construction Start
TB-GR-37 3/6/2017 7/9/2017 8/8/2017 9/7/2017
TB-CU-44 3/24/2017 7/13/2017 8/12/2017 9/11/2017
TB-GR-15 3/3/2017 7/14/2017 8/10/2017 9/7/2017
there are approximately 750+ lines with this type of data
With this I am hoping to show based on the month (also drill down to show the week) how many plans we are scheduled for. I need the other columns to display the other count of dates; Design Need Date, IFC Plan Start Date, and Actual Construction Start.
I have tried using a Date Table and have that displaying on the x-axis. I then need the count of the different dates as the y-axis. However, when I try to do that I always get the counts as being the same for each of the 4 date categories. I believe this has to do with only being able to use the relationship only once between the Date Table and one of the 4 date categories.
Is there any way to display multiple dates for a single line across the same line and bar chart?
Thanks