Stored chart customization parameters

  • 1 July 2022
  • 1 reply

In LOOKER, If it is needed to create a group of metric performance charts, each with individual customzations (max, min, step size, scaling, etc), can these sets of custom parameters be stored in a CSV file or SQL table to be accessed and applied?  If possible, we want to avoid the need to manually edit the charts every time we generate a new set of charts.  Thanks.

1 reply

If I have understood you correctly, you can achieve this with parameters and liquid variables with sql.

Basically have a parameter field on the view you want to parametrise and produce custom dimensions, measures based on the parameter i.e. if parameter value is “min”, then run “min(...)” on the source.