How to have a drill down on a Adhoc chart in dashboard that will open the table report in new tab with Parameters.
Click on create Dashboard and add a Adhoc chart .
It will open up the Adhoc view editor and then choose a data source for the chart.
Below screenshot shows sample from Emplyee report with City as filter
Save the Adhoc chart and return to Dashboard. This will add chart as dashlet
Prepare a table report taking parameter as City. In this example I have used Sample report Accounts.
Click on Map Parameters and map the parameters as shown below.
Right click on chart dashlet and click on properties and then to Hyperlink Tab.
Tick mark on "Enable Hyperlinks:" and choose 'Open new page' from Action option.
Click on browse and choose table report saved earlier.
After choosing the report add Parameter at the end like below:
Click Ok and now run the dashboard and click on the bar chart. This should open table report in new tab with specified parameter value from Dashboard.