Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Model driven app chart counting two tables

I have a case where I have a model driven app and two tables.


One table is named penalty

One is named cases raised


Penalty gets populated with records automatically from there a user then submits a case related to the penalty via a lookup.


The user would like a chart to be added to the dashboard where it is a chart which compares the number of penalties received that week against the number of cases raised that week.


This would mean the chat with me to get the sum of all the rows in each tables filter. 


I know how to do this with one chart to one table but I am unsure how to do this from one chart to two tables. 








Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are Your Ready?

Test your skills now with the Cloud Skill Challenge.


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (59,087)