Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I see a strange issue of data mismatch between desktop and access point.
Also i observe that it is happening only on specific scenario.
Scenario: My condition is if % is < 85 %, we need to count how many times it occured
Note: % here is a calculated column. Chg. and Base are coming from source data.
Scenario1:
Period | Chg. | Base | % | Condition |
2016010 | 32.5 | 168 | 0.193452 | Yes |
2016011 | 77 | 184 | 0.418478 | Yes |
2016012 | 42.5 | 176 | 0.241477 | Yes |
2017001 | 19 | 168 | 0.113095 | Yes |
2017002 | 103.5 | 176 | 0.588068 | Yes |
2017003 | 60.5 | 176 | 0.34375 | Yes |
2017004 | 76 | 176 | 0.431818 | Yes |
2017005 | 59.5 | 160 | 0.371875 | Yes |
2017006 | 100 | 184 | 0.543478 | Yes |
2017007 | 119.5 | 160 | 0.746875 | Yes |
2017008 | 118 | 184 | 0.641304 | Yes |
2017009 | 75.5 | 176 | 0.428977 | Yes |
In this scenario, all periods are under 85 %, hence it is displaying 12 both in desktop and access point
Scenario 2:
Here is i see the problem
Period | Chg. | Base | % | Condition |
2016010 | 232 | 168 | 138.1 | No |
2016011 | 112 | 184 | 60.9 | Yes |
2016012 | 192 | 176 | 109.1 | No |
2017001 | 104 | 168 | 61.9 | Yes |
2017002 | 32 | 176 | 18.2 | Yes |
2017003 | 0 | 176 | 0 | Yes |
2017004 | 112 | 176 | 63.6 | Yes |
2017005 | 152 | 160 | 95 | No |
2017006 | 168 | 184 | 91.3 | No |
2017007 | 136 | 160 | 85 | No |
2017008 | 112 | 184 | 60.9 | Yes |
2017009 | 152 | 176 | 86.4 | No |
For period 2017007, % is 85.
Wherever we have the exact threshold i'm getting mismatch
Here is my expression
if(sum(if(Aggr(Alt((sum(Chg))/sum(Base),0),[Employee ID])<0.85,1,0))=1,
sum(if(Aggr(Alt((sum(Chg))/sum(Base),0),[Employee ID],Fiscal_Month)<0.85,1,0)),0)
With this i expect Count to be 6 (Based on Condition=Yes). It is coming as 6 in desktop and 7 in access point. I suspect it is picking 2017007 which has exact 85 %
However i'm getting the right result in desktop and in access point it is incorrect.
Please help
Thanks
Satish
Yes. Using the same.
After data refresh i'm seeing this in DESKTOP vs Access Point
This is fixed by setting the threshold limit to 0.8499 instead of 0.85 (Desktop and access point matches)