This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello!Yes, this can be done. First you have to create a filter in the
view file. This filter will appear in the explore just as any other
dimension or measure. You can then apply a dashboard filter to this
filter in the view.By using this syntax:WHER...
Hello!This should work in a table
calculation:substring(${xxxxx.yyyyy},1,position(${xxxxxx.yyyyy},"-")-1)Where
xxxxx.yyyyy is the measure containing the group name.This calculation
takes a substring from the column xxxxx.yyyyy, starting at position 1...
Make a measure with “type: count” in the view file. measure: count {
type: count }If you then use this measure together with the dimension in
your picture, you will achieve your desired outcome.
In a join you can use fields: []-parameter in the join. That way you can
join a single column, without polluting the explore with lots of
irrelevant
fields.https://docs.looker.com/reference/explore-params/fields-for-join
Hey @AhadLafi ! You should be able to use an advanced filter with the
extract_hour()-function. By using this you make sure to only show data
from the current hour: extract_hours(${timedimension}) =
extract_hours(now())Combine this with “is in the pas...