Hi
I am trying to create a single table in looker where some of the measures are adjusted with a page date filter and some measures in same table are not. is that possible?
Page date filter would be “Month to day”.
example table
Area | Invoiced Revenue | Invoiced revenue last 5 days |
---|---|---|
East | 100 | 30 |
West | 150 | 70 |
if i then change date filter on page to “yesterday”
Then invoiced revenue changes but invoiced revenue last 5 days is still the same
One way i can think of fixing this now is to have this in two tables, where date filter affect on but not the other. I do not find that to give a good user experience from and overview perspective and then you would not be able to sort on column and see effect on the other
Other option is to have a merge query where date filter does not apply to one of the merge, but as i understand i should always try to avoid merge querys
Any good ideas ?
all help is much appreciated.