BOTTOM ANALYSIS

[#1]

Hello,

I am trying to get the bottom analysis using slider for my items and i'm not able to get it.Please help me out.

You can find the chart in the attachment.

Thanks

Atul

[jsanchezh]

Try to order them in "Ascending" mode for the Y-Value and select Higher than vBottom in the graphic properties

[santhoo_san]

is this you are looking for? see the attachment

[#4]

No Sir, I want top 10 bottom items and the data should be played with the slider.But using the dimension limit,i'm not able to get it.

[#5]

@jsanchezh‌Where do i get the graphic properties???

[santhoo_san]

Hi Atul,

it is working based on the slider selection only.

you just need to do

1. Sort your bar graph Y value Ascending

2. Remove Dimension Limit - Limit restriction

3. Enable chart scrolling - with your variable (vBottom)...

see the screen shot of  of bottom 5 below

[#7]

Dear Sir,

I just need Bottom 10  analysis with dimension limits.

[antoniotiman]

Hi Atul,

it depends on Null Values.

Try Calculated Dimension instead of @Chemical

=Aggr(If(Not IsNull(#AGEINGQTY), @Chemical),@Chemical)

Regards,

Antonio