I have a table that lists the case status in the rows and the case type in the columns. In the metric I want to see in that table, I want to have the sum of the deviation for each case, and I also want to see the number of cases for each type and status. I would like all this to be in the same table, so to achieve this, I should add a dropdown filter that gives me two options: one to count the number of cases in the deviation column and another option to sum the values in the deviation column. I couldn’t find how to do this, can anyone help me?
Thank you for your query!
Please try the steps in the following article: https://cloud.google.com/looker/docs/reference/param-field-parameter#specifying_allowed_values
This will allow you to achieve being able to dynamically change the values shown in the y-axis of a chart on your dashboard by parameterizing the y-axis.