Skip to Content
Former Member
Jul 18, 2013 at 12:22 AM

Open a link several consecutive times even if the trigger cell does not change



I have a chart that I want to use to drill down in a Webi report, and I want the user to be able to click on a single data point repeatedly and have the report open up every time. The scenario might be an executive talking in a presentation, clicks the chart to open a report, discusses the report and closes it, someone asks a question about the report, executive clicks the same data point in the chart (important: the executive has performed no other action or change in the dashboard since the first time he clicked the chart) and discusses the report again, closes the report, someone else asks about the report, executive becomes irritated but clicks the chart anyway to open the report again, etc.

I can set a URL button and a trigger cell and it works fine, but triggering the URL requires that the value in the cell change somehow. Otherwise any clicks on a data point beyond the first click, if the trigger cell hasn't changed its value, will produce no effect. Is there a way to make a link get triggered based solely on clicks, regardless of whether the value in the trigger cell changed or not?