Posted: 1 Aug 2018 17:01 EDT Last activity: 20 Aug 2018 15:20 EDT
How to add an Interactive Charts with drill down in Section/Harness
We have a requirement to show a Pie Chart in Dashboard, and user will get the drill down data in report format once clicked on a wedge. However I could not find how to do it using Chart control using report definition as a data source in Pega7.3 version.
I am running Pega 7.3 version. pyTaskDuration is a perfect example and I have created a similar one. However, how to embed that in a section as a chart format, so that when user clicks on any wedges it will show the data. I have a requirement to show the chart in Dashboard and user can see it on Login.
Posted: 2 years ago
Updated: 2 years ago
Posted: 2 Aug 2018 21:19 EDT Updated: 2 Aug 2018 21:18 EDT
You can first place the chart in separate dynamic layout and use your report definition as data source. Then configure event action in actions tab of dynamic layout. Then have event as click and action as report definition and from there u can display your report by clicking on chart.
Thanks for the approach but there are couple of challenges. 1) Clicking on the chart will run the report because of the layout control, but we need the wedge filter for the drill down. Basically if we have 3 wedges W1, W2, W3 on the chart and if user selects only W2, then popup should show only data for W2, no need to run the entire report again in popup. 2) we can't have 'Wedge moving out' animation if we click on a wedge, as there is an onclick control on layout.
If you can get me a solution for the point# one, mentioned above, it will be a great help.
Pega provided a hotfix to open the drilldown report on click of a chart wedge in the same tab. we have used composite tab group layout in our portal to open the report with chart in a separate tab. Pega version 7.3