Hello!
I'm not sure if this is in the correct area so please forgive me if I put it in the wrong spot!
I am having some trouble trying to figure out how to build a filter for visualization for our upper management. Basically, what I need:
- Side by Side visual of contract information for contracts that were terminated and started in any given period of time.
- The type of information will be contract base rates, number of equipment, etc.
The problem I'm running in to is with the filtering. So if our COO wants to view all contracts that were terminated in March vs all contracts that were started in March, I can use the standard visuals but because the date filter would have to be set for both, it's only going to pull contracts that have a start date in March AND a termination date in March. I want all contracts that have a termination date of March OR a start date in March. And, I need to do it in a way where the COO can change the date range as he needs it.
I just can't figure out the filtering. I'm not sure if a customized visualization would help fix this or if there's a way to set up two filters in one that use the "OR".
Anyone have any ideas?
