Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I can do a boxplot graph when it involves a single value, For example:
name earnings
John 100
Paul 120
George 80
Ringo 90
However will i be able to do this for an expression?:
name net earning
John 100 - 10
Paul 120 - 12
George 80 - 8
Ringo 90 - 9
Jo
you can calculate the net earning in the script and can use the same in the front end rite
I have a problem calculating the expression in a script ... that would be best, but my data will not co-operate.
Try like this:
Before the box plot expression try to add one more expression (this should be the first expression) , you can make it as invisible or hide and then for the box plot you can utilize the same expression name for the value
Thanks David - I want to use an expression though ...
I think I might be asking the wrong question ...
name/earning will not work cos it needs some other dimension (for example might need to clasify the names further into maybe musician/singer and then look at the classification as a box plot ...
load * inline [
name, rate, hrs, type
john, .1, 100, muso
paul, .2, 120, singer
george, .1, 90, muso
ringo, .2 80, singer
]
I used this:
LOAD * INLINE [
name, earning,type
john, 100, muso
paul, 20, singer
george, 900,muso
ringo, 800, singer
];
LOAD * INLINE [
aname, rate, hrs, atype
aJohn, .1, 1000, amuso
aPaul, .1, 200, asinger
aGeorge, .2, 1800, amuso
aRingo, .2, 1600, asinger
];
These both worked but the expression is:
min(Aggr(hrs*rate,,[atype]))
I had to change the expression the box plot wizard gave.
Hi Webmaster
I madea mistake and put a helpful on the wrong comment and then I clicked assumed answered and i cannto go back!
Jo