I want to compare the part to total. Ex: Selling performance (each of the bizunit) vs Total.
Can we use a duo chart to do that? like a line to present the total tend, and the bar chart to present the one biz unit’s performance. The bizunit’s performance can be changed based on the filter, but the line chart will only show the total.
Here is my current calculated field:
I am using: percentOfTotal(count(payeeid))
combine with an ifelse caculated field: ifelse({variable_cash_pcnt} < 0.50 OR varcash=0, “a <50%”,
{variable_cash_pcnt} >= 0.50 and {variable_cash_pcnt} <=0.9999, “b 50-99%”,
{variable_cash_pcnt} > 0.9999 and {variable_cash_pcnt} <=1.4999, “c 100-149%”,
{variable_cash_pcnt} > 1.4999 and {variable_cash_pcnt} <=1.9999, “d 150-199%”,
{variable_cash_pcnt} > 1.9999 and {variable_cash_pcnt} <=2.4999, “e 200-249%”,
{variable_cash_pcnt} > 2.4999 and {variable_cash_pcnt} <=2.9999, “f 250-299%”,
{variable_cash_pcnt} > 2.9999 and {variable_cash_pcnt} <=3.4999, “g 300-349%”,
{variable_cash_pcnt} > 3.4999 and {variable_cash_pcnt} <=3.9999, “h 350-399%”,
{variable_cash_pcnt} > 3.9999 and {variable_cash_pcnt} <=4.4999, “i 400-449%”,
{variable_cash_pcnt} > 4.4999 and {variable_cash_pcnt} <5.00, “j 450-499%”,
{variable_cash_pcnt} >=5.00,“k 500%”,
null
)
How to use pre filter or other function to get the total percent to avoide the filters?
Hi @Cindy
Using Level Aware Calculation in QuickSight we can create total at the certain level before applying any filters .
Below expression will calculate overall selling performance before applying any visual level filters.
sumover({selling performance},,PRE_FILTER)
Please follow the documentation & democentral for more examples.
Thanks
Vinod
1 Like