Hi PoChang,

Not sure if I completely understood your requirements, but if you want to restrict data in your chart one way would be of achieving it via filters. So a user can select the user and click on search, based on which the chart would be shown. You may need to use non persistent entity to achieve this.

You could alternatively also think of using sunburst charts – although they are not two separate charts but you can create root to leaves relationship. Reference link here. Do note that it may take a while before you understand the concept fully and be able to achieve it in Mendix.

The easiest option would be the one with NPE.

Good luck!