Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

drill down

am using a graph which has grouped dimensions 0-3,4-6 etc shown in form of bars

as a dimension am using a cyclic group created

now what i want when i click on 0-3 it should give me all the values as from 0 1 2 3

how is it possible?

can i use getselectedcount(groupname)?

7 Replies
Anonymous
Not applicable
Author

Hi,

Can you share the sample file, it will be helpful to understand the requirement.

Regards

Vinod Gadiputi

arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi ,

Please find Attachment it will help you.

Thanks,

Arvind Patil

Anonymous
Not applicable
Author

i canno see any attachment

Anonymous
Not applicable
Author

i dont want to create a drill down group

i want a drill down view as described above

rahulpawarb
Specialist III
Specialist III

Hello DG,

As a workaround, I have created below sample script which will load ProductId and its respective sales figures. Also created a bucket for ProductIds.

Sales:

LOAD ProductId, Sales, If(ProductId <=3, '0-3', '4-6') AS ProductBucket;

LOAD * INLINE [

ProductId, Sales

0, 1000

1, 2000

2, 4000

3, 8000

4, 16000

5, 32000

6, 64000

];

Post this created  a Drill Down Group on Dimension tab (Products: ProductBucket -> ProductId) and used it as dimension in bar chart.

Hope this will serve the requirement.

Refer the attached sample application.

Regards!

Rahul Pawar

Kushal_Chawda

Add that field in Drill down group which you want show as dimension when clicking on bucket

Anonymous
Not applicable
Author

am using a cyclic group

and a combo chart

how is this possible in that case

and in that group i have 5 fields

and in each field i have values in range0-9