Hello ,
Let's say I have 3 date type fields on my data:
-date of requisition
-date of start
-date of end
An entry will have these 3 dates. Now, as an example, these 3 dates could be 09/05/20, 10/06/20, and 11/06/21.
Can I set up in the script a time dimension that allows me to filter all the others by? For example, this date dimension will allow me to filter by 06/20 and show all the entries with any date dimension with that value(06/20) whether it is the date of requisition, of start or end.
Once I have this I could have a master time dimension that allows me to filter by FY for example. Currently, I derive all the date dimensions from a master calendar that allows me to filter, for example, by date of end.FY, but not FY itself.
Thanks in advance!
