Hi,
I am totally stumped on how to do this....please help 🙂
Below is a simple smaple of my data. A column of accounts and a column of Last used dates for exchange.
a) The blank fileds are thoes that have not yet activated Exchange. I am using a count blank menasure to add them up
b) The dates represent the last used date of the for an activ user. I am using a count value to add thoes accounts up.
- the data syas we have 5 accounts in total, 3 are activated and 2 are not activated. I can do a simple Stacked Bar chart of this
I wnat to add a slicer, and filter by realaitve date.. <who has used exchange in the last 30 days>...
I want the utput to show me a stacked bar chart with 3 stacks. One stack for accounts who are not activated, one stack that fits the filters requirement of "who has used the product in the last 30 days" and then the third is for the uses who have not used the product in the last 30 days.
| Account | Exchange last used date |
| Chad | Sep 1st |
| Brad | |
| Mat | Jun 10th |
| Dave | |
| Sam | Aug 10th |
