Steps to create Dashboard with drilldown

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