We use Holistics for large-scale BI reporting - but if we ever want to dig into a customer account, we need to copy a unique identifier and paste into our CRM system (bespoke in-house build).
I’m sure it’s possible to build a custom dimension to create a link but my SQL is almost non-existant. I’m basically looking to create a custom dimension that looks like this:
1. Create a custom dimension.
Let me make an example. The left field is static and the right field is from our database. 'https://www.google.com/' || {{ #THIS.feedback_exp }}
Here I’m using Postgres, and the syntax to glue 2 fields is ||.
Let me know the database that you’re using so I can recommend the correct syntax for it.
2. Set the format to HTML when you build the chart