using class function

[ali_hijazi]

Hello got a fact table against which I'm counting the number of regressions between two selected dates

my expression is as follows:

count

  (DISTINCT

  {

  <

  OFFICIAL=

  ,ROF_CATEGORY=

  ,TYPE={'reg'}

  ,RECORD_TYPE={'detection'}

  ,Year=

  ,MonthYear=

  ,Month=

  ,CALENDAR_DATE={'>= $(vFromDate) <=$(vToDate)'}

  >

  } ID

  )

now what I want is to create a line chart that categorizes the above expression's result into brackets of 100 as length

I added a pivot table and added a dimension as follows:

=Class(TPK,100,'x')

and as expression the above expression yet I got the following:

please advise

[anbu1984]

Can you post sample app

[john_s_w_wood]

Hello Ali

Is TPK a 'fact' value?  You may need to use the aggr function eg   aggr(nodistinct sum(TPK) , Yearorsomething)

[john_s_w_wood]

ie class( aggr(nodistinct sum(TPK) , Year),100,'x')

[ali_hijazi]

yes it is a fact table column

[john_s_w_wood]

Ok. Ill try and send you an example shortly

[john_s_w_wood · Accepted solution]

Hello Ali

Heres an example using aggr and class. Hope the context is correct. KRegs John