Create view to count the child records of all parent entities

(0) Share

Report

Posted on by Community Member

Hi there!

I have a custom entity named "Service" and a custom entity called "Type" .

I have N:N relationship between them. I would like to add a chart to my dashboard with all services with their types.

So lets say i have 10 services last month. 5 Interior Car wash type and 5 exterior car wash type. I would like to show them in chart by type.

How is that possible?

Edit: Updated description

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Community Member on at

Like (0)

Report

Any ideas?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi shak ,

please post more details, your description is not clear:

1) we are talking about standard or custom entity?

2) post a full example

Thanks

If you found the answer helpful, please mark as Verified

Join my network on LinkedIn Follow me on Twitter

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY

Independent Contractor

http://www.francescopicchi.com

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi there!

I have a custom entity named "Service" and a custom entity called "Type" .

I have N:N relationship between them. I would like to add a chart to my dashboard with all services with their types.

So lets say i have 10 services last month. 5 Interior Car wash type and 5 exterior car wash type. I would like to show them in chart by type.

How is that possible?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi shak,

it is a simple task.

Please refer to this site: https://crmchartguy.wordpress.com or search google for "dynamics crm create a chart".

In few words:

1) Create a view (Service of this month with Service Type included in columns)

2) Create a chart based on this view, selecting Service Type field in chart fields

Please let me know if you solve

If you found the answer helpful, please mark as Verified

Join my network on LinkedIn Follow me on Twitter

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY

Independent Contractor

http://www.francescopicchi.com

Was this reply helpful? Yes No
PekkaSahlsten 827 on at

Like (0)

Report

(deleted post)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The problem is that i have N:N relationship. There is no lookup field Service Type , but a sub-grid with Service Types. Therefore i can do this as you instructed

Was this reply helpful? Yes No
Sindre Wetting on at

Like (1)

Report

This is very similar from, the previous lymentioned, CRM Chart Guy: crmchartguy.wordpress.com/.../nn-relationship-charts-in-ms-dynamics-crm

Was this reply helpful? Yes No