G'day,
Some months ago we spent time evaluating different "business analytics" tools, mostly because our existing tool QuickSight is garbage ( slow & ugly ). After evaluating a bunch of tools, we agreed that Looker Studio seemed like a good option.
However, we have discovered a major issue that we have been unable to solve, and which ironically QuickSight can do.
The thing we need to know how to do is to pass a variable into the WHERE clause, so we can filter. The primary use case if having a filter for the customer/tenant ID.
We are not alone. There are many people asking about this, but nobody from Google has replied since this was opened back in 2020. ( Is Looker Studio another abandoned Google project? )
https://support.google.com/looker-studio/thread/79585050/how-can-i-use-parameters-in-a-mysql-connect...
If we used BigQuery then maybe it is supported, but apparently:
- not Mysql ( https://cloud.google.com/sql/docs/mysql )
- and not Postgres ( https://cloud.google.com/sql/docs/postgres )
- and not AlloyDB ( https://cloud.google.com/alloydb/docs )
https://support.google.com/looker-studio/answer/9002005?hl=en#zippy=%2Cin-this-article
And there are other people talking about filtering with nice videos
https://visionlabs.com/blog/fieldids/
And some suggestions about literally hiding fields
https://support.google.com/looker-studio/thread/75023445/how-to-hide-a-report-level-filter-control-i...
... If we can't solve this, I guess we're going to be looking for a better tool.
Thanks in advance,
LinkedIn
Twitter
