Question

Calculations on whole dashboard using LookML

  • 24 January 2022
  • 0 replies
  • 11 views

I would like to create a parameter in LookML which  normalises all the metrics on a dashboard when selected. 

 

So the parameter would have two possible labels: Normalised, or Absolute. When the normalised parameter is selected, all metrics on the dashboard should be divided by number of users. However I am not sure how to write some LookML that would then do what I need.

 

I understand that the value parameter needs to reference a dimension, but I am unsure of what dimension, because I want the parameter to divide several dimensions

 

  parameter: metric_type {
    type: number
    allowed_value: {
      label: "Normalized"
      value: "???"
    }
    allowed_value: {
      label: "Absolute"
      value: "??"
    }
  }

 

Am I going about this the right way?


This topic has been closed for comments