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 2024 data.
The Grey boxes are constants that will update based on the filters . Here the Top Row, ie, Active head count, for the selected month will pull from database . where as for the following months the active headcount will be the Expected Ending Headcount of previous month. Ie, For Feb month the Active Head Count= Expected Ending Headcount of Jan month.
The rows for Hires, Terms, Promotion, Demotion, Transfer will be Input boxes, where by default it will show case the value of respective metrics for that month, but it will be an input field, so the use can input any value there if they want to change the numbers they would be able to change it from dashboard itself. for any month ,any cell.
Expected Ending Headcount is the sum of all other metrics for that month , ie, Current Active headcount+ hire+ terms+ promotion+ demotion+ transfer.
This expected Ending headcount calculated by taking sum of all the user inputs will be the active headcount for the next month.
Can anyone help to achieve this functionality in quick sight. Is there any possibility to get this by using a grid report or any relevant options to achieve the same functionality???
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 , ?
Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!
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 total will be the sum of all the rows for the specific moth. and the next month first row will be the result of the sum of last month. like that i need to update. If any similar structure is possible for this kind of requirement, that is also fine.
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 the parameters in the desired way with your base values. It is doable but is going to be a little effort intensive task.
I’m marking Shahid’s response as solution to your question.
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
Now I need to Add this active headcount +hires+terms to get expected ending headcount. But while doing that i am getting aggregation error
That is the only issue i am facing. Other than that Was able to get the similar functionality using this method.
