put ranks of expression on x-axis

[ali_hijazi]

Hello

I need to accomplish the following:

first I have and expression that counts the number of regressions by test (TPK)

my expression is as follows:

count

  (DISTINCT

  {

  <

  OFFICIAL=

  ,ROF_CATEGORY=

  ,TYPE={'reg'}

  ,RECORD_TYPE={'detection'}

  >

  } ID

  )

when grouped by TPK I get the following chart:

what I want to accomplish is to have a bar chart where on the x-axis I want to have the following values:1,2,3,4,5,6, etc....

where on 1 i should have 14

on 2 I should have 5

on 3 I should have 16

on 4 I should have 39

etc....

Please advise

[#2]

Try putting this in dimension

If(Aggr(count(DISTINCT{<OFFICIAL=,ROF_CATEGORY=,TYPE={'reg'},RECORD_TYPE={'detection'}> } ID), TPK) =1, 14,

If(Aggr(count(DISTINCT{<OFFICIAL=,ROF_CATEGORY=,TYPE={'reg'},RECORD_TYPE={'detection'}> } ID), TPK) =2, 5,

etc....

Thanks,

Vinod Kumar V

[mdmukramali]

Dear Ali,

Can you attach the sample apps .

Thanks,

Mukram

[ali_hijazi]

I solved it as follows:

in the dimension I put the following:

=AGGR(rank(SUM(AGGR($(vDetection.TotalRegression),TPK)),1),TPK)

but I'm facing a sorting issue I want to sort result in descending order but I'm getting results as follows: