Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to create a set of sheets, all tied to the same data source, but that have different data filters that aren't applied to the other sheets.
For example - I want to have a "Today's Orders" sheet and a "Yesterday's Orders" sheet - and have them come from a single data source with a date filter.
Currently, I create two complete separate data sources but I don't really like this method. Any ideas or thoughts if this is something that is in the works?
From what I understand, you should be able to create flags for 'Today's Orders' and 'Yesterday's Orders' and use them in the set analysis for sheet representing them. So for example Orders for Today can be flagged as 1 and orders from Yesterday can be flagged as 0
If(OrderDate = Date(Today()), 1, If(OrderDate = Date(Today() - 1), 0)) as DateFlag
And then on your Today's sheet use the following set analysis statement
{<DateFlag = {1}, Date = , Month = , Year = , YearMonth = >}
And then on your Yesterday's sheet use the following set analysis statement
{<DateFlag = {0}, Date = , Month = , Year = , YearMonth = >}
HTH
Best,
Sunny