Forum Discussion
Stacked Area Chart Visualization and Date Range
I would like to use a stacked area chart to compare data across date ranges.
I have a column of "How to" data and would like to compare this data using a date range filter, i.e. "Back2School" (Aug 31 - Sept 30), "Black Friday" (Nov 24 - Nov 28), and "Winter Break" (Dec 19 - Dec 31). My data contains a single [CreateDate] column.
I was thinking that I would have to create a New Column of data and use an IF statement such as -
Back2School = if(name[Create Date] = ...
in order to create sperated columns to use for comparison in the stacked area chart - however...
1. I am uncertain of the string to use
2. I am not sure this is the most effective way to accomplish my objective
Any feedback?
Regards,
G
What I lack in ability I make up for in tenacity; I was able to solve my own problem.
B2S = IF(AND(print_consumer[Create Date] >= DATE(2016,9,1),print_consumer[Create Date] <=DATE(2016,9,30)),[Case ID])
This copied all Case ID between the dates indicated and placed then in a new column. This was repeated for multiple date ranges representing several define dates ranges and then I was able to bring them in as stacked area chart values.
1 Reply
What I lack in ability I make up for in tenacity; I was able to solve my own problem.
B2S = IF(AND(print_consumer[Create Date] >= DATE(2016,9,1),print_consumer[Create Date] <=DATE(2016,9,30)),[Case ID])
This copied all Case ID between the dates indicated and placed then in a new column. This was repeated for multiple date ranges representing several define dates ranges and then I was able to bring them in as stacked area chart values.