VC BI Query Drill Down ... pie -> table

[Former Member]

Hi All,

In VC i added form -> bi query -> table and pie chart , and then pie chart - > table ...i need drill down ......if i click the pie chart then the values will be dispalyed in the table how can we do that

can you please expalin the step by step procedure for the drill down technique.

if you people send material is also but i need step by step procedure in visual composer from creating model onwords.

Thanks All,

Sriram

[Former Member]

solevd by me.

[Former Member]

Hi

You need to follow the following steps -

1. First create BI query with input variable & the optional variable for the field which you want to pass from the chart.

2. Then create Input form - > Query - > First Chart.

3. Drag this query once again in the model.

4. Then from the output of the chart join this to input of the new query. & drag the table from this query.

5. in the connecting line between chart & new query pass the field as '@infoobject_key' from the chart. (this will be field on category axis.

6. Then save & deploy the model.

This is called as 'drill down'. If you have any issues then let me know.

Regards

Sandeep