Forum Discussion
% data vs total in funnel
Hi There,
I have a little question. Like you see in the picture below I have made a funnel with the total amount and one with the cost.
The light green is showing the total amount of the different countries (see total in the matrix graph below). If I select the total everything is looking good. But when I select eg Belgium in this example the amount of Belgium (16,12k) is shown as 100%. What I like to have is that the 100% is replaced by the % that Belgium is representing from the total amount (llight green).
Hopefully somebody can help me out.
Thx
Tom
3 Replies
v-juanli-msftCommunity Support
Hi TomCuypers
Which columns do you add to the funnel chart?
I can't see how to get the amount of Belgium (16,12k) for funnel chart in the matrix visual.
I would suggest you share an example dataset (just contains the data used in both visuals), then which columns to use in each visual.
Best Regards
Maggie
Hi Maggie
Thx for your help, please find below the data set I used.
In my first post I just put a "count" values on the amount field to see hov many times a country recieved an amount.
Hopefully you can help me after the additional info :)
Thx
Tom
- v-juanli-msft
Hi TomCuypers
If you just add "amount" and "cost" column to the Values field of the Funnel visual, it is not strange that the % of data doesn't show correctly.
The percent shows based on the "Group" and "Value".
Please review this article to learn how to use the Funnel chart.
Best Regards
Maggie
