I am developing a dashboard .I have bar chart with 3 colors of bars Red,Green,Yellow with values.
I am derivinga formula here ex: NPS which is summation of Green color - Summation of Red colors values of the bar.Also on the top i need to show the status of the R,G,Y summations of values of the graph.
Right now i am doing this manually , but i have a need to make them work dynamically to my filters.right now they are not dynamic.
Pl help me how do we in tableau, if its possible, i saw some where it is possible in tableau.
Attached is the package.
I have grouped the same colors to show the status of color for aggreation but displaying is a real problem as a single line.Also the calculation of NPS bases on colors (Agg of Green -Agg of Red) how do we do in tableau.because these are values , not the fields.