I have some requests regarding Looker ML and Visualization. Not sure if my requests are doable in Looker now. Pls find details below.
Background: In general, would like to dynamically create groups or sets for locations or users etc. and then create dynamic dates/periods to compare metrics of the two groups in two different periods.
I want to create a view that will be similar to the content in above picture.
Group 1 and Group 2: user customized groups. Could be locations or users that are in interests.
Period 1 and Period 2: customized date ranges or dates.
Measure 1 and Measure 2: measures defined in LookML. Could be sum, counts, averages or maybe table calculations.
In this case, the goal is to compare two groups’ performances in two different periods. Want to be able to change dates or values in groups.
I have been search around but could not figure out by myself. Also found out Parameters or Filters but not sure how to apply exactly. In Tableau, once I created filters and added dimensions in view, I can create sets or groups based on the result in view such that I can use this set to do other analysis which is very convenient. Is this also doable in Looker?
Could you pls point a direction?
Really appreciate any input here!