Data drilling of a bar chart into a line graph with multiple metrics

Hi all 

Now I have an idea in building the chart and with the data drilling function. However, I am struggling to visualize it. 

The main idea: I have a bar chart which contains the conversion rate of web user to final subscription, which break down by different countries like as follows 

b38f1a70-745d-4152-bfd1-9302d9256499.png

What we want to do is to add a data drilling, that when we click into the bar chart, there is another shows the follows:

  • The no.of new visitors with time development 
  • The no.of converted customer  with time development 

Like this,

99057097-21f5-48d3-9594-3417459ea0bb.png

but couple of changes: 

Change the conversion rate to absolute number, and 2 lines at the same graph

Example: For our premium product in London, we click into it, and would like to see how much new users and how much of them are converted in each week

Is there any way that I can achieve it? Thanks!

0 0 238
0 REPLIES 0
Top Labels in this Space
Top Solution Authors