Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello Ali
Heres an example using aggr and class. Hope the context is correct. KRegs John
Can you post sample app
Hello Ali
Is TPK a 'fact' value? You may need to use the aggr function eg aggr(nodistinct sum(TPK) , Yearorsomething)
ie class( aggr(nodistinct sum(TPK) , Year),100,'x')
yes it is a fact table column
Ok. Ill try and send you an example shortly
Hello Ali
Heres an example using aggr and class. Hope the context is correct. KRegs John