6 Replies Latest reply: May 23, 2013 3:09 AM by Gert Harren

# Aggr with something like above in dimension?

Hi,

i m trying to visualise fractiles from data like this:

 ID Score Value 1 1 0 2 1 0 3 1 0 4 1 0 5 1 0 6 2 1 7 2 0 8 2 0 9 2 0 10 2 0 11 3 1 12 3 1 13 3 0 14 3 0 15 3 0 16 4 1 17 4 1 18 4 1 19 4 0 20 4 0 21 5 1 22 5 1 23 5 1 24 5 0 25 5 0 26 6 1 27 6 1 28 6 0 29 6 1 30 6 1

I want to get an graph like

or

It's easy to get something like

 Score count Avg 1 5 0 2 5 0,2 3 5 0,4 4 5 0,6 5 5 0,6 6 5 0,8

but i ve no idea how to calculated the data to get something like

 Score count2 count2_2 Avg2 1 5 17% 0,0 2 10 33% 0,1 3 15 50% 0,2 4 20 67% 0,3 5 25 83% 0,4 6 30 100% 0,4

and to use the count2 or count2_2 as a dimension.

Any ideas?

Thanks a lot,

Gert

• ###### Re: Aggr with something like above in dimension?

FOR COUNT2, WRITE EXPRESSION

rangesum(Above(sum(count),0,rowno()))

• ###### Re: Aggr with something like above in dimension?

Hi,

the "problem" isn't the calcuation in a straigth table, the problem is to use the data in an graph like this:

(sorry, the graphs weren't shown)

so I need the values in an calculated dimension...

Gert

• ###### Re: Aggr with something like above in dimension?

See attached qvw

• ###### Re: Aggr with something like above in dimension?

Thanks a lot :-)

• ###### Re: Aggr with something like above in dimension?

Hi,

sorry, clicked to fast ;-)

num(...) in the dimension doesn't calculate the "correct" (or better "wished";-)) value:

count2  is calculated and represents the x - value,

avg2 the y - value.

see example2.xlsx...

any ideas?

Greets

Gert

• ###### Re: Aggr with something like above in dimension?

Hi,

no one with another idea?

Gert