Dynamic Measures

Hi @JATIN,

This sounds like a great use case for table calculations and custom fields. It sounds like you are interested in users creating dynamic, on-the-fly metrics. We can create on-the-fly filtered measures (i.e. sales amount filtered by Jeans, or Tshirts) using the custom fields feature available in the explore interface.

As for dynamically changing the label of Sales Amount measures, we can accomplish this using liquid in the label parameter of our lookml measure. The liquid variables that are supported in the label parameter can be found here (these will have the La tag next to them). The liquid variables you would use here would be dependent on the conditional logic of the measure name.

Another option for making your measure dynamic is by using liquid templated filters, which will allows users to select the dimension they wish to filter the measure by on the front end, via a filter. This approach is outlined here.

Please visit us at help.looker.com if you would like to explore these options further!