Looking for a help to build a report which shows the last 3 activity timeline for a specific company.
Hello,
If you want to create report for a specific company, you can navigate to -
Report Builder > Activity Timeline (object from Matrix Data that stores Timeline information) > Choose fields you want to view.
Now to drill down the report for a specific company and show the last 3 timeline entries -
- Navigate to the Report settings options in the report to view only the recent Activity timeline for a specific company.
Here, as per the use-case, I have opened the Report settings ( the small gear icon in yellow ribbon at the Report ), went on to selecting the Ranking and Sorting, selected Created Date under Select Field, Order By Descending to get the recent/last Timeline activity and Limit value as 3 to only see the last 3 activity timeline posted. (refer to the below screenshot)
You can either put a filter criteria like in the below screenshot that shows the filter on company name field to drill on a specific Company -
OR
You can also search for any other company by directly navigating to the ‘search here’ box under Company field and it’ll fetch you the recent 3 Activity Timeline for a searched company.
Hope this helps! :)
Thanks for your response. I am actually looking for the top 3 activities for all the companies in a single report.
Thanks
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.