Drilldown on html report

Writing to get your help. Please take a look. Thank you in advance.

Below is description:

  1. Main Report displays current count of units as follow:

$var_currentCount

2. Variablefor main report is $var_currentCount is SELECT units FROM table where entityin ('$var_entities') 3. Main Report is on dashboard1that is filtered by selection of entityfrom dropdown that is on a top of dashboard1I need to create view details report that will be opened from link that is on Main Report. View details report need to be filtered by '$var_entities' that is selected on a dropdown on dashboard1.So, practically, I need to pass current entity selection in dropdown on dashboard1 to drilldown report.I’m wondering if it is possible. Thank you
  • What Grafana version and what operating system are you using? – Grafana 8, Linux

  • Whatare you trying to achieve? – I need to pass current entity selection in dropdown on dashboard1 to drilldown report.I’m wondering if it is possible.

  • Howare you trying to achieve it? – tried all sorts of links but does not work

  • What happened? – did not work

  • What did you expect to happen? – view details report to open filtered by entity selected on dashboard where main report is located

  • Can you copy/paste the configuration(s) that you are having problems with? – NA

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactlywhat they were. – details view report opens not filtered

  • Did you follow any online instructions? If so, what is the URL? --NA