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

    Aggr with something like above in dimension?

      Hi,

       

      i m trying to visualise fractiles from data like this:

       

      IDScoreValue
      110
      210
      310
      410
      510
      621
      720
      820
      920
      1020
      1131
      1231
      1330
      1430
      1530
      1641
      1741
      1841
      1940
      2040
      2151
      2251
      2351
      2450
      2550
      2661
      2761
      2860
      2961
      3061

       

      I want to get an graph like

      or

       

      It's easy to get something like

      ScorecountAvg
      150
      250,2
      350,4
      450,6
      550,6
      650,8

       

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

      Scorecount2count2_2Avg2
      1517%0,0
      21033%0,1
      31550%0,2
      42067%0,3
      52583%0,4
      630100%0,4

       

      and to use the count2 or count2_2 as a dimension.

       

      Any ideas?

       

      Thanks a lot,

       

      Gert