1 Reply Latest reply on Aug 23, 2018 12:53 PM by Jim Dehner

# Create a grouped bar chart based on counting the matched criteria from calculated field

Hi all

The question is actually complicated. Now we have a sampled table as below.

The table consists of the country information, date information which is grouped into weeks (2 weeks of data is available), No.of Visits, No.of registration and No.of order.

What we want to do in tableau are as follows:

1. Calculate the conversion rate for 1.Visits to Registration 2.Registration to Order and 3. Visit to Order   (Which is done and attached in the workbook)

2. Use those rates to set an standard to count how many countries are eligible i.e Visits to Registration > 10%, Registration to Order>5%, Visit to order>1%

3. Plot a grouped bar chart to show how many countries matches each criteria in every week from the start from 1-Jan-2018 e.g 3 countries in this week that Visits to Registration > 10% , 4 countries that Registration to Order>5%,  3 countries that Visit to order>1%

Now the 1st task is straight and have been done.

But for 2nd task, I used the LoD to break down the conversion rate, and it just works when I want to show only 1 KPIs, but cannot make all data to form the grouped bar charts

ANd at the same time I am not sure how to make the 3rd steps.....

The data is as follows

 Country Week Visits Registration Order China 8/5/2018 100000 30000 5000 United States 8/5/2018 150000 45000 7500 Germany 8/5/2018 50000 7500 500 France 8/5/2018 40000 3200 500 Canada 8/5/2018 75000 5000 250 Russia 8/5/2018 60000 4200 350 China 8/13/2018 120000 31500 5600 United States 8/13/2018 180000 47250 8400 Germany 8/13/2018 60000 7875 560 France 8/13/2018 48000 3360 560 Canada 8/13/2018 90000 5400 280 Russia 8/13/2018 72000 4536 392