I’m not sure if that is something possible to do or not in Looker but I would like to calculate the difference between two measures that are in the same explore with both having a different filter date. I’m having a hard time getting both numbers filtered independently from one to another in the same explore so I could then do my table calculation.
See screenshot beow:
Looking forward for your help,
Hey Florian! Neither are perfect but I’ve done this two ways:
Hope this helps! I’ll be back at my office in a week and can elaborate more if you still need more help 🙂
Thanks for the response!
I have tried the option two but the inconvenient is that it only filter for a specific time frame for each measure. In other words it’s not dynamic and the end user can’t look at next month or last month.
Would love if you could elaborate when you have some time…
Do I understand by ‘filtered independently’ that you want to calculate the difference between sfdc_prior_opportunity.contract_end_date_date and sfdc_revenue.close_date where AT LEAST ONE of the two is in the past 7 days, but not necessarily both?
In that case, I would say you should delete both the filters as shown in your screenshot, hit the Custom Filter checkbox and add:
With the table calculation (not sure which of yours would be the start and end date):
Thanks for the help here! I actually figured it out using this method here..
Glad you were able to leverage the LookML-based filtered measures for your use case.
For even more flexibility and giving your users more power, I really recommend using custom fields, and I find that sometimes it is hard to discover that they exist, so I wanted to point you to them here: https://docs.looker.com/admin-options/tutorials/managing-bizusers/bizuser-features#enabling_custom_fields