Forum Discussion
Relationships between tables
Hi Anonymous ,
What I would like to be able to do is create tables in the report such as:
Customer ID (Table 1) || Count of Meeting ID (Table 5)
*This works with Customer ID (Table 1) || Count of Activity ID (Table 4) - so why does the above not work?*
And I would like to be able to create e.g. pie chart in the report showing:
Legend: Activity Type (Table 3)
Values: Count of Meeting ID (Table 5)
By my test with your sample data, do you want to create the visual like below?
If that is your desired output, please create the relationship like below.
If you still need help, please share your desired output so that I could understand your requirement better.
Best Regards,
Cherry
Hi Anonymous ,
What I would like to be able to do is create tables in the report such as:
Customer ID (Table 1) || Count of Meeting ID (Table 5)
*This works with Customer ID (Table 1) || Count of Activity ID (Table 4) - so why does the above not work?*
And I would like to be able to create e.g. pie chart in the report showing:
Legend: Activity Type (Table 3)
Values: Count of Meeting ID (Table 5)
By my test with your sample data, do you want to create the visual like below?
If that is your desired output, please create the relationship like below.
If you still need help, please share your desired output so that I could understand your requirement better.
Best Regards,
Cherry