Chart Expression

[bharatkishore]

Dear All,

I am using a Pivot chart. I have taken one name dimension and one stage dimension(Total 2 Dimension). In that stage(Field) dimension i have 6(Sub- fields) i.e.

1)Achieved

2)Breached

3)Cancelled

4)Inprogress

5)Manually Cancelled and

6)In Progress

Attached image for your reference..

Now i have written an expression for calculating the count task number i.e.

=count({<name={'MOET HENNESSY ASIA PACIFIC/HK'},[Link Date]={'>=$(VarLase4Month) <=$(VarFinMaxDate)'},[Fiscal Month]=,[FY Year Name]=>} task_number)

Now my problem is I need calculate the two subfields i.e. and i need to display those calculated ones in the pivot chart...

1)Achieved + Breached

2)Achieved/Achieved+Breached

Can you please suggest me how can i achieve this.

Regards,

Bharat

[Gysbert_Wassenaar · Accepted solution]

Perhaps you can use 8 expressions and remove the status dimension:

Create an expression vExpr and use this in the expressions

vExpr: count({<stage={$1}, name={'MOET HENNESSY ASIA PACIFIC/HK'},[Link Date]={'>=$(VarLase4Month) <=$(VarFinMaxDate)'},[Fiscal Month]=,[FY Year Name]=>} task_number)

1) Achieved: $(vExpr('Achieved'))

2) Breached: $(vExpr('Breached'))

3) Cancelled: $(vExpr('Cancelled'))

4) Inprogress: $(vExpr('Inprogress'))

5) Manually Cancelled: $(vExpr('Manuallycancelled'))

6) In Progress: $(vExpr('Inprogress'))

7) Achieved + Breached: [Achieved] + [Breached]

😎 Achieved/Achieved + Breached: 1 + [Breached]

[bharatkishore]

Thanks a lot Gysbert....It worked..

Regards,

Bharat