Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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]
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]
Thanks a lot Gysbert....It worked..
Regards,
Bharat