You’re offline. This is a read only version of the page.
156
Hi,
I have created 3 entities : Project, Consultant and ProjetConsultant
The Project Entity properties : Name, Start Date, End Date
The Consultant Entity Properties : Name
The ProjetConsultant Entity Properties : Name, Name (from the Projet Entity), Name (from the consultant Entity)
There is a Many to One Relationship between ProjectConsultant and Project Entities.
There is a Many to One Relationship between ProjectConsultant and Consultant Entities.
Therefore, there is a Many to Many Relationship between Project and Consultant Entities.
I would like to create a Project Entity Chart which will display the number of project for each consultant based on the Ongoing Project View (already created).
How can I achieve this ?
Thanks,
Arioule
@Arioule I made a video showing you how this works. https://youtu.be/285dynzFl1M
You aren't going to be able to build this chart from the project entity because project consultants are a 1:N relationship with project, and you can't include :N fields in a 1: view.
What you need to do is build your chart at the joiner level (project consultants). Create a view that includes fields from project and consultant, then use that as the basis of your chart.
You can then add the chart to a dashboard along with project level detail.
#1
stampcoin
17
#2
mmbr1606
15
Super User 2025 Season 1
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
