Drilldown even

[Anonymous]

Hi All,

My user is comfortable with Drilldown Group ( he don't want cyclic group).

So, I would need to overcome the below functionality :

( "The drill-down function automatically goes down to the next level when there is only one value on the current level. So what happens is most likely that you for some data only have one value in your Priority field.")

i.e., I need to come up with a work around to display the values based on the current level (and not automatically go down to next level when there is only one value

Please advice.

[srchilukoori]

You need to build a work around using the getpossiblecount() function.

[srchilukoori]

Try the logic from the attached app.

[marcus_sommer]

I believe there isn't much to customized on the drilldown group and you will need to build an own logic. Maybe with a variable as dimension which will be controlled by button(s) or an inputbox and/or which changed by an OnSelectionChange trigger and/or by user-selections (which queries the getfieldselctions and makes a counting on these selections) and/or you queries your required group-hierachy with a pick(match()) lookup:

dimension: $(varDimension)

varDimension: if(count(Dimension1) < 2, Dimension2, Dimension1) // query the results from user-selections

I think it will be not quite easy to build such a logic and I assume you will have to combine several from the above mentioned possibilities. Nevertheless I hope it's useful for you.

- Marcus

[petter]

It seems that it is possible to trick it into the functionality you want by introducing dummy rows in the data.

This can also be handled by a separate table linked to your main table to make it more clean and efficient.

Here is the quick and dirty solution:

DrillDownGroup:
LOAD * INLINE [
  L1, L2, L3, L4,V
  A, A2, A3, A4,2
  A, A2,
  A, A3, A5, A6,3
  A, A3,
  A, A4, A7, A8,5
  B, B2, B3, B4,6
  B, B3, B3, B5,7
  C, C2,C3,C4,8
  C, C2,
  C
];

Row numbers 5,7,12 and 13 are dummy rows to make the drill-down see that it has more values than one but in the front-end you can select "suppress when value is null" under "Settings for Selected Dimension" on the Dimensions tab in the properties of the Straight Table.

[Anonymous]

Hi srchilukoori,

On selection in your Dim1 listbox, it drilldowns to Dim2 in your bar chart.

However, I would like the Dim1 selection to display only the selected value (eg CA, US ) in the bar chart.

ie., if I select US in Dim1 , I would like to see US in Chart. Same for CA.

[Anonymous]

Hi Petter,

in your example, if I create a listbox for L1, and, when I make a selection on only one value in L1, it is creating a drilldown from L1 level to L2 level in the chart. However, I would not like the chart to jump to the next level automatically just because I selected only one value in listbox

[Anonymous]

Hi Gurus,

This issue is still pending.

When selecting one or more values in a list box, the line chart , which has only one line at the highest group level, is automatically jumping to next drilldown level. Please help me to overcome this

[Anonymous]

Hi All,

this solutions is still not working

Please help

[petter]

Give me some motivation then - even though I solved your original problem - you didn't give me a "like" / "helpful" or "answered". I don't want to spend a lot of time helping out unless there is some chance of getting positive feedback...