Hi , We have a requirement to create a visual like the below chart. [image] Here, We will be having a Start date filter, where the user can select any month, then the visual will display the next 12 months data. ie, if the user select Jan 2024 in filter , the graph will showcase jan2024 to Dec…

Hi currently as such chart is not available in QS but you can achieve this by creating cards and using parameters to achieve your desired output.

Can anyone, help to get the similar kind of visual ? Or using parameters , how can we build the calculations to update the Expected Ending Count as the active headcount for following month of selected month , ?

Hi @Ganga , maybe you can try small multiples: [image] Create small multiples in Amazon QuickSight | Amazon Web Services We’re excited to announce the launch of small multiples in Amazon QuickSight at AWS re:Invent 2022! Small multiples is one of the most powerful data visualization feat…

Hi @Xclipse Small, multiples will not work in my case. its for comparison basically. My Scenario is different, If u can check the input I have provided, u will get. In My Case, We have to get a grid like design, where in each cell user should be able to provide input/similar to parameter. and the t…

Hi @Ganga , As mentioned by @Shahid_Muhammad above, you can build this by using parameters and creating the grid by positioning them between two table visuals (that drive your top and bottom row) using free form layout. This will involve using 60 parameters and lot of custom calculations to add up …

Hi @ArunSanthosh , I was able to achieve the functionality using Pivot table and parameters to change the inputs. and used the below calculations to get the Active headcount [image] [image] [image] Now I need to Add this active headcount +hires+terms to get expected ending headcount. But while…

Creating GRID Report with option to have user input on cells

Q&A

WLS-DM August 7, 2024, 4:04pm 8

Hello @Ganga, since you posted a new topic, I will archive this question. We can follow-up on this issue on the most recent post. Thank you!

Topic		Replies	Views
Creating a metric with inputs that can be modified by a dashboard user Q&A analysis , parameters , quick-sight , filters-controls-and-parameters , calculations , Business-Intelligence-Engineer	2	42	February 10, 2025
Apply the filter on specific column in table visualization in Quicksight Q&A quick-sight , Business-Intelligence-Engineer	3	67	October 11, 2024
Creating period comparisons with Quick Sight's periodOver and periodTo functions Technical Articles error , calculations	32	25440	November 21, 2024
5 Past periods sum in 5 columns Q&A date , period-over-period , quick-sight , Business-Intelligence-Engineer	15	373	December 22, 2023
Multiple aggregation calculations are showing errors when using with Lag Function Q&A analysis , quick-sight , calculations , Business-Intelligence-Engineer	10	172	August 13, 2024

Creating GRID Report with option to have user input on cells

Related topics