I am trying to create a dashboard with a metric that automatically recalculates values based on a user’s input. e.g. Assuming commission earned on sales in a department is evenly split across all employees within that department. In the dashboard, I want to add a feature which would allow the user to simulate how much each person would earn by adjusting the number of sales or employees in the department. Is this possible in quicksight?
Figured out how to achieve this with parameters and a calculated field shortly after posting this. Leaving the answer below if someone requires a similar solution in future.
Assuming I want to simulate the average commission based on the number of employees in the department.
First create a parameter with a number data type and a suitable default value (lets call this parameter “employeecount” in this example). You can now use the parameter in a calculated field e.g. Assuming you have an existing field for the “commission” values, your calculated field syntax would be {Commission}/${employeecount}.
You can now create a visual with this calculated field and add your “employeecount” parameter as a control with a slider or text input style. This would allow the dashboard user to select a value which would recalculate the commission per employee.
Hello @Yram,
Welcome to the QuickSight community! It is great having you here.
I have marked your second message as the solution, thanks a lot for sharing this with the community!
Kind regards,
Andres.