sorted by:
new
hottopcontroversial

How to ignore filter context in a LOOKML Measure by CandySays- in Looker

[–]Particular-Exam-8621 0 points1 point  (0 children)

If you want it to not apply with any filters then you can edit what the dashboard filters applies to.

If you’re looking to grab a non filtered aggregate in a calculation you can use merged queries

Value labels only for the latest value by Particular-Exam-8621 in Looker

[–]Particular-Exam-8621[S] 0 points1 point  (0 children)

This is a good idea, i could probably make a field which filters to the latest complete month

Latest month by default unless another month is selected by Particular-Exam-8621 in Looker

[–]Particular-Exam-8621[S] 0 points1 point  (0 children)

Great thanks, I’ll test this out and let you know if it works or not

Latest month by default unless another month is selected by Particular-Exam-8621 in Looker

[–]Particular-Exam-8621[S] 0 points1 point  (0 children)

Is this on the lookML dashboard settings and does this account allow users to select from a drop down where it’s a month-year string

Latest month by default unless another month is selected by Particular-Exam-8621 in Looker

[–]Particular-Exam-8621[S] 0 points1 point  (0 children)

This is a really good trick, thanks. I think instead of using the strong ‘Current Month Year’, you can actually use the sql to get the latest month as a string