Forum Discussion

gfair's avatar
gfair
Regular Visitor
9 years ago
Solved

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" (A...
Need Help
  • gfair's avatar
    gfair
    9 years ago

    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.

gfair's avatar
gfair
Regular Visitor
9 years ago

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.