Below formula will not make the date on Wed 11-Oct under Ontime a 0, is still comes up as a 1. It works fine for the next line Tue 10-Oct.
Expression and image may not be enough to understand what is going on... would you be able to share a sample?
Here is the qvf file.
The point of the expression is that within the Category, the Status for the Day under question is either a Breach or Ontime, it cannot be both.
Which tab do you have the chart from the image above?
Updated this old file (original at work) to get the same issue. Refer Milestone by Day tab.
So you are expecting this to be 0?
No, if you scroll down to sub heading labelled 11 WSS SE & Midanz Start and choose 11/10 that is where the issue resides.
You legend, I spent hours on this, NODISTINCT was all that was missing. Will double check tmrw on my full dataset but appears to the trick and read up more on NODISTINCT.
I think what you need to read about is Grain Mismatch within Aggr() function and then read about NODISTINCT
Grain Mismatch is one of the Pitfalls of the Aggr function
Thanks I will read the above.
Retrieving data ...