Good Morning !!!
I am a newbie & getting hands dirty to Grafana.
We have a requirement where to create a dashboard with table visualization.
It is an hierarchy Office level aggregation report.
Need a drill down level table matrix report while clicking a particular office.
The data looks like this, the expectation is 001 & 002 records will have the ExpandFlag indicator(hidden parameter) to expand or not, based on that + symbol should be shown.
If the Indicator is Y then + symbol should be shown & if it is N there should not be a drop down + symbol.
Since 001 & 002 has indicator as ‘Y’ it will have + symbol & when clicking the + symbol, we have to call / execute another query passing the 001 to fetch the subs offices under 001 which is 001-0 & 001-1 records. similarly, for 002 to fetch its sub office records under 002 which is 002-0 and 002-1 record.
Kindly requesting your thought & help how to achieve & resolving this issue.
Office ID, Amount Credit, Amount Debit, Running balance ExpandFlag(Hidden)
001 100 -20 80 Y
001-0 20 0 20 N
001-1 80 -20 60 N
002 60 -20 40 Y
002-0 50 -20 30 N
002-1 10 0 10 N
Thanks & Regards,