How can I get the field title (for example) information into a data link, so that I can do a proper drill down from the Bar Gauge?
e.g. just using the Value is useless, I need to be able to know the value of the ${__field.Title}, to know which of the bars the user clicked on, and drill into only that bar. Using the __field_name results in only returning the column heading formthe SQL, which isn’t what I need, plus if two bars have the same Value of “2”, I can’t differentiate, makes it very counter-intuitive.
2 Likes
I’m not pretty sure but ${__field.name} is what you want?
No, that returns the column heading, I need something that can return e.g. $__cell_0, i.e. how do I identify the specific bar the user clicked on?
1 Like
Excellent question – I’m looking for exactly the same thing. Any solutions?
1 Like
Excellent question – I’m looking for exactly the same thing. Any solutions?
I came across the same problem, using SQL as the datasource.
I worked around this by formatting the query as time series instead of table and adding a column named time into the query… in my instance, now() as time.
This allowed me to use ${__series.name} in the data link.
NOTE: To give each bar the correct title, I also needed to change my Field>Title in the Visualization pane to {__series.name}... I was previously using __cell_0
