Setting up the basic setting which will be done for all solution is mentioned here

Sample Table Structure:

ID SampleName Branch State Location

1. Sample1 branch1 state1 india
2. Sample2 branch2 state2 us

Now I want to create a cyclic drill containing

1. Branch
2. State
3. Location

Loading info and creating in order load

Drill_below:

load * inline

[

SampleName, SampleName_Label

Branch, Branch Name

State, State Name

Location, Location Name

];

Once data is loaded there are 2 WAYS to VIEW drill_below inFilter (available in sense app)

It is good but wouldn’t able to get the default value and multiple SELECTIONS may be enabled. Although this works in a way where client won’t care if first load drill is visible and selected.

Much more are available use which ever fits your criteria

Now We have drill selection ready now to link CHART to the Drill.

Thus we have selected drill to connect chart to drill

Have two following ways:

• Use if condition
• Use Pick Match

As the above two are obvious, if the info is large, creates lag in chart reloads,

Thus the following approach,

Uses the following function capabilities, in Size, Create dimension

looking like

$(=if(GetSelectedCount(SampleName_Label)=0,’Location’,only(SampleName)))

Hence create the measure as per requirements; gives the cyclic group.

Setting up the basic setting which will be done for all solution is mentioned here

Sample Table Structure:

Id SampleName Branch State Location

Now I want to create a cyclic drill containing

Loading info and creating in order load

Drill_below:

load * inline

[

SampleName, SampleName_Label

Branch, Branch Name

State, State Name

Location, Location Name

];

Once data is loaded there are 2 ways to view drill_below inFilter (available in sense app)

It is good but wouldn’t able to get the default value and multiple selections may be enabled. Although this works in a way where client won’t care if first load drill is visible and selected.

Much more are available use which ever fits your criteria

Now We have drill selection ready now to link chart to the Drill.

Thus we have selected drill to connect chart to drill

Have two following ways:

As the above two are obvious, if the info is large, creates lag in chart reloads,

Thus the following approach,

Uses the following function capabilities, in Size, Create dimension

looking like

$(=if(GetSelectedCount(SampleName_Label)=0,’Location’,only(SampleName)))

Hence create the measure as per requirements; gives the cyclic group.