# Datasets for report **URL:** \ **Category:** Q&A\ **Tags:** Business-Intelligence-Engineer, quick-sight\ **Created:** [April 16, 2025, 11:58am UTC](https://community.amazonquick.com/t/datasets-for-report/45058 "2025-04-16T11:58:56Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![LParkes](https://avatars.discourse-cdn.com/v4/letter/l/f6c823/32.png) [@LParkes](https://community.amazonquick.com/u/LParkes)\ **Post date:** [April 16, 2025, 11:58am UTC](https://community.amazonquick.com/t/datasets-for-report/45058/1 "2025-04-16T11:58:56Z")
I am building a report and I want to see advisor call volume (which is in agent schedule and statistics dataset) and i’d also like to see advisor offline time for activity type (which is in scheduled agent time). Is there a way I can display both visuals on the same sheet of my report or do I have to put them on different tabs? ---
**Author:** ![Giridhar.Prabhu](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/giridhar.prabhu/32/27789_2.png) [@Giridhar.Prabhu](https://community.amazonquick.com/u/Giridhar.Prabhu)\ **Post date:** [April 16, 2025, 12:11pm UTC](https://community.amazonquick.com/t/datasets-for-report/45058/2 "2025-04-16T12:11:32Z")
Hi @LParkes You can display both visuals on the same tab. If you have common fields between the two datasets then you could also setup filter interactions between the two visuals. ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [April 29, 2025, 4:15pm UTC](https://community.amazonquick.com/t/datasets-for-report/45058/3 "2025-04-29T16:15:00Z")
Hi @LParkes, It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post? If we do not hear back within the next 3 business days, I’ll close out this topic. Thank you! ---
**Author:** ![LParkes](https://avatars.discourse-cdn.com/v4/letter/l/f6c823/32.png) [@LParkes](https://community.amazonquick.com/u/LParkes)\ **Post date:** [April 30, 2025, 8:00am UTC](https://community.amazonquick.com/t/datasets-for-report/45058/4 "2025-04-30T08:00:40Z")
Hi, Apologies, I have a slightly different scenario if you could possible help? My report is built using dataset “WFM scheduled agent time” and I have a line graph showing teams tech and non tech issues. Image below: ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/0/e/0e219954f5abf27a1abfc48e9beca62d62c0192a.png) ! ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/3/3/336ea3808653d29fb2ce9032a8b83b1d1448a614.png) I would like to add to this graph another 2 lines to show advisors working from home and those from office. I can see that this information is in “Location” which is under the dataset “WFM scheduled agent days” When I click on my current graph (pictured) and go to add in location, it reverts me back to the agent time dataset. If I want a graph to show the home vs office, do I need to do this on a separate graph? Many thanks! ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [April 30, 2025, 5:12pm UTC](https://community.amazonquick.com/t/datasets-for-report/45058/5 "2025-04-30T17:12:01Z")
Hi @LParkes, Yes, you would need to separate visuals. Unfortunately, Quick Sight does not allow a visual to be built off of more than one dataset. To build a visual that incorporates information from 2 datasets, you would need to perform a join on those datasets, which may not be applicable based on the included fields and if there is one that matches up identically. You can find additional information regarding table joins at the link below: > **[Joining data - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/joining-data.html)** > > Join tables, files, and SQL queries using the Amazon QuickSight join interface. Let us know if you have any additional questions! ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [May 12, 2025, 3:01pm UTC](https://community.amazonquick.com/t/datasets-for-report/45058/6 "2025-05-12T15:01:04Z")
Hi @LParkes, Following up here as it’s been awhile since we last heard from you; did you have any additional questions regarding your initial post? If we do not hear back within the next 3 business days, I’ll close out this topic. Thank you! ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [May 22, 2025, 3:47pm UTC](https://community.amazonquick.com/t/datasets-for-report/45058/7 "2025-05-22T15:47:19Z")
Hi @LParkes, Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community. Thank you!