Shared filter for multiple dimesnsions

[AndreyL]

Hi,

I’m trying to do the shared DateRange filter for using in 2 dimensions.
1 dimension is a just table TableX with timestamp column named “created”
2 dimension is the same table TableX but with a ranking function

Originally the idea of the Ranking function described in the article https://help.looker.com/hc/en-us/articles/360024267673-Sort-by-Pivots-Rank-with-Other-Bucket-and-Per...
But I’ve added some tuning: I do ranking in a certain period, not for the whole table, as in the article. The results may very differ because ranking changes dynamically during different periods.

And I don’t understand, how can I use 1 date filter for both dimensions. The standard way (join column) doesn’t work, because the filter must be applied in Ranking SQL before join.

Now I’m temporarily using 2 date range filters - separately for each dimensions and I’m setting both with the same values. And it works perfectly.
But maybe Looker has a way to use 1 filter for 2 dimensions?

[Maddie]

Hi Andrey,

I think it would be useful if you could please share the relevant snips of LookML.

You might be able to achieve this using a templated filter, but I’d need to see the code first before I can suggest a solution.

Best,
Maddie | Redkite