Hi all,
I'm importing several managers account in Looker Studio throughout NEW Search Ads 360 connector. My goal is to create a dashboard with table and graph that allows the user to change dynamically some metrics (custom columns) in order to customize his view.
I add a drill-down list (with multiselect option) that help the user to select his favourite account between all the available accounts.
In the database that I obtain after the link I have every custom column of every manager account (with this description of the metrics that says "This custom column is owned by [manager account name]). So If I put every custom column of every manager account in a table as optional metric I obtain an infinite list of metrics that the user can select on his hand.
In my opinion this isn't a good solution for a UX and also technical point of view. I would like to manage in a different way this issue.
I thought to following solutions:
OR: 1 parameter managed with a drill down list with the name of every custom column that trigger a CASE WHEN statement inside the graph or table --> the user can choose his metric (BUT he need to do it 1 time per metric or I should create N parameter for N columns in the table)
OR: a CASE WHEN statement that shows a metric only when the user select a manager account (BUT I have to set the drill down list with "one select" option)
Question: are there more smart solutions for this problem?
LinkedIn
Twitter
