Question

Stored chart customization parameters

  • 1 July 2022
  • 1 reply
  • 13 views

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.

Reply