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?
% of Users in reference to time after a filter
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
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!