Unanswered

Charts not showing for hierarchical records

(1) Share

Report

Posted on by FilipB

Hi guys!

We are using an out of the box hierarchical relationship between Accounts and Orders, to show Orders that are related to child Accounts (e.g. a "Master Account" has multiple child Accounts, and these child Accounts have Orders; we are showing these bottom-level Orders on Master Accounts).
We succeeded in supporting this functionality in two ways already:
1. Out of the box "Associated Records" view with "Include related" set to "on"
2. A custom view with a plugin activated on Retrieve Multiple that is programmatically filled with appropriate records
With both of these methods we succeeded in showing the appropriate records in the subgrid, but we are getting no data in the chart. Screenshots of the charts and subgrids are provided.
We need help in determining what is the cause of this issue and how can we manage to support this functionality?

Categories:

Power Apps Pro Dev & ISV

fagron_plugin_cha...

fagron_associated...

I have the same question (0)

All responses (4)

Answers (0)

cchannon 4,702 Moderator on at

Like (0)

Report

This is interesting. Have you tried setting up this entity as a Virtual Entity instead?

Was this reply helpful? Yes No
FilipB 23 on at

Like (0)

Report

To all interested parties,
we got on a call with MS support regarding these issues. The conclusions are:
1. The ootb charts do not work with the "Include Related" logic (obviously)
2. Apparently the charting engine somehow bypasses the registered plugins (at least the custom ones). As far as we could see, a request was sent to some "old" SOAP endpoint

Was this reply helpful? Yes No
FilipB 23 on at

Like (0)

Report

Thanks for the suggestion!
Using VE seems a bit to "heavy" for something that we consider should be an ootb feature. We will probably default to Power BI for this.

Was this reply helpful? Yes No
sonamdema7991 2 on at

Like (0)

Report

Just trying for test purpose!

Was this reply helpful? Yes No