aggr help

[bhavvibudagam]

Hi Experts,

Can any one please help me on below issue.

I have a table like below.

I have filtered 01/18/2017 from due date only that date related System related records i am able to see.

But in the table I have 02/17/2017 and 02/2017 dates also I have. That date related systems not able to see getting null values.

For system dimension I have used

=agg(only({<name={'system'}>}value),issuenum)

Please let me know am i missed any thing in the dimension expression.

Issue due this week measure expressions are like below

=Count(distinct {<DueDate={">=$(=Date(Weekstart(Max(DueDate),0,0),'MM/DD/YYYY'))

<=$(=Date(Weekend(Max(DueDate),0,0),'MM/DD/YYYY'))"},

Status-={'pending'}>}issuenum)

Thanks in advance

[sasiparupudi1]

May be

Count(distinct {<DueDate={">=$(=Date(Weekstart(Max(DueDate),0,0),'MM/DD/YYYY'))

<=$(=Date(Weekend(Max(DueDate),0,0),'MM/DD/YYYY'))"},

Status-={'pending'},name={'system'}>}issuenum)

[sasiparupudi1]

May be

Count(distinct {<DueDate={">=$(=Date(Weekstart(Max(DueDate),0,0),'MM/DD/YYYY'))

<=$(=Date(Weekend(Max(DueDate),0,0),'MM/DD/YYYY'))"},

Status-={'pending'},name={'system'}>}issuenum)

[bhavvibudagam]

Hi Sasidhar,

Thanks for your reply.

Actually system is not the direct dimension its derived by name and value fields with below expression.

=agg(only({<name={'system'}>}value),issuenum)

Please help to include this one in the measure expression.

[sasiparupudi1]

Count(distinct {<DueDate={">=$(=Date(Weekstart(Max(DueDate),0,0),'MM/DD/YYYY'))

<=$(=Date(Weekend(Max(DueDate),0,0),'MM/DD/YYYY'))"},

Status-={'pending'},value={"=agg(only({<name={'system'}>}value),issuenum)">}issuenum)