Steps to create Dashboard with drilldown
- Create Drilldown Form
- Create Chart in Drilldown Form
- Add Interactive Chart
- Add Datasource (Open chart properties and add datasource)
- Provide the KPI name and title
- Add Interactive Chart
- Query Customization using C# code
- Write query
- Open code editor
- Execute the query. Then, save and exit.
- Write query
- Drill down from a chart to another form
- Add Column chart
- Provide the chart labels and values
- Open Control Governance and enable view and select Drill down behaviour
- Open Dashboard form and click on chart
- Add Column chart