LinkedIn
Twitter
I am trying to implement this parameter to have a dropdown to dynamically change a pie chart dimension. What I want to achieve is to be able to switch between two different pie chart views (one based off of the dimension of server Location and another based off of server Disposition/Status), but both will have the same metrics.
I added the following parameter called View Type (with the intent to use it in a dropdown):
And then added a field called Label to correspond with the parameter.
And then added a new field ChartView that ideally will change between my database fields Data Center and Disposition, depending on what is selected based off of the parameter View Type:
I then tried to add in my dropdown (based off of the parameter) and pie chart:
Drop down seems to look fine, however, pie chart will not work and the error that gets thrown is this:
This is the set up of the pie, and to my understanding and research, should work (based off this article I found https://phoenix-analytics.medium.com/looker-studio-dynamic-metrics-e4d147103877). Where the dimension I want (ChartView) will change dynamically based off of the parameter that is selected in View Type. And therefore my pie chart can change dimensions with this field. Any ideas on what might be causing the error?
