% of Users in reference to time after a filter

  • 1 March 2023
  • 1 reply

Hello, everyone!

I am trying to create a table that contains things such as ‘month’ and ‘no. of users’. This look belongs to a dashboard where there is a filter where people can interact with it and select a ‘product category’ to see the number of users who bought from a specific product category in a specific period of time.

My question is: I want to be able to see this percentage by reference to the time period, meaning, for example if I filtered for a category like ‘Phones’:

- Month | % of Users
02.23 | 30%
01.22 | 35% 

The ‘30%’ would mean that in February 30% of the users who purchased a product bought from the category ‘Phones’.

How can I do this?

Thank you!​​​​​​​

1 reply

Hello, you can use a liquid parameter to filter the measure by product category. See this Filtros basados en plantillas y parámetros de líquidos  |  Looker  |  Google Cloud   you can see an exemple of dynamic measure where they filter by category to count. I hope you find it helpfull!