Forum Discussion

Adam_Snyder's avatar
Adam_Snyder
Qrew Member
2 days ago

Creating a pie chart in a grandparent table

I’m in PR and we use QB for managing our media requests. If a reporter reaches out with an inquiry we log it in a media requests table. Media requests has a parent table of reporters (reporters can have multiple requests). Each reporter has a media outlet (think CNN or ABC News) parent (a media outlet can have many reporters. One of the things we track is the coverage of the media requests generates and score it with a multiple choice field on the media request entry (positive, negative, or neutral). 

So I have a pie chart that show the breakdown of the coverage with those options. I can pull that report into the reporter table on place it on the reporter form and it filters it down showing the score for that reporter across all their requests.

What I want to do is pull that data into media outlets so I can see the score for that media outlet across all their reporters and the reporters requests.

I want a similar pie chart on the media outlet form.

What’s the best way to go about this?

 

 

reports

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 days ago

    np, it's easier than you think.

    Your reporters table probably has a field called related media outlet. Look that up down to media request and I suggest calling it what it is, [record ID of media outlet].

    next, just create a field of report link field type, call, perhaps [report link of media requests].

    on the left side, configure it with simply record ID, that will be the record ID of the media outlet and then on the right side navigate to locate your app and then The media request Table and locate that field record ID of media request.  During that navigation watch for any pop-up blockers as you may have to click typically near the top right of the URL to unblock the pop-up. 

    Then just put that report on the form, if it's a legacy style form, then you just put the report link field on the form and specify one of those pie charts as the report to use, in Form Properties.