Organization Name
Assicurazioni Generali S.p.a.
Description
New logic for the waterfall chart in order to let it become a “waterfall build up” (horizontal and vertical).
- by default, the chart should set on one of the axes all the values of a dimensional attribute (either sorted by alphabetic /ascending/descending / custom order as requested in another "idea") and as a final bucket it should report the total sum of the measure of all the dimensional attribute values
- the measure for each dimensional attribute value could either be positive or negative (therefore subtract or add up to the total sum according to the value of that dimension)
- possibility to show values in each stack of the waterfall as percentage (of the total), absolute number or both together
Use Case and Business Need
In an HR analytics context, visualize the contribution of the different leaving/hiring reasons (voluntary, subsidized, retirement, …) for the employees leaving/joining the company, custom ordered.
More details
Basically, instead of plotting the difference between the previous and the current value, plot the current value, starting from the provious one (and going up or down based on the measure sign or by the sign option configured for that bar by the user).
Other details that could better explain the requirement:
- possibility of “add subtotal” by clicking on one of the dimensional attribute value; this operation should create another column of subtotal (that should be custom-named) which sums all the previous values and from which the waterfall “re-starts” to arrive to the total
- possibility to determine the sign of the measure for a dimensional attribute value by clicking on it. For instance, we have the attribute “inflow of people” expressed in absolute numbers. With this desired functionality, the user would click on it and select subtract to edit the sign to minus
Original Idea Number: 16262f9fda
