Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I hava data like this below
1,2,3,4,5,-----100,110,102,103,104
I have used Class function but it is showing like this below
0<=x<10 11<=x<20 21<=x<30 31<=x<40 41<=x<50 51<=x<60 61<=x<70 71<=x<80 81<=x<90 91<=x<100 100<=x<104(instead of More)
I want to show in X-Axis
0-10% 11-20% 21-30% 31-40% 41-50% 51-60% 61-70% 71-80% 81-90% 91-100% More(Above 100)
Can u please suggest me on this.
Hi,
In dimension you can try this ways also assume this example
LOAD
RecNo() as Id,
Rand()*100 as Amt
AutoGenerate(150);
And in the straight table chart
Dim:- =if(Id<100, Replace(Class(Id,10),'<= x <', '-')&'%', 'Above 100')
Expre:- sum(Amt)
But check the expression should calculate % in your expression it is example.
Regards
Anand
Hi,
You can try this expression and replace the <= x < string and concatenate % symbol but if your expression calculates the % values then it is better you can use this expression
=Replace(Class(Attendees,10),'<= x <', '-')&'%'
Regards
Anand
Hi,
In dimension you can try this ways also assume this example
LOAD
RecNo() as Id,
Rand()*100 as Amt
AutoGenerate(150);
And in the straight table chart
Dim:- =if(Id<100, Replace(Class(Id,10),'<= x <', '-')&'%', 'Above 100')
Expre:- sum(Amt)
But check the expression should calculate % in your expression it is example.
Regards
Anand