Hello, I am a business user with no access to the scrip, using the IE plugin. I am trying to create an expression that Distinct Counts when the shipdate = newdate for the customer. The expression works correct when I have a month selected but when I look trended for the yr, the counts do not match previous months totals, like when I have a single month selected. The problem I am running into is if there are more then one shipdate, QV does not know to choose the first ship date to match to the new date and then does not get counted. I want QV to only count one time when the shipdate=newdate. I have tried min() around the Shipdate but not luck. Is there any other functions that I can add to my formula that would tell QV to look at the first shipdate to match to the newdate. Here is my formula: Thank you,
I've had to do this exact same thing 50 times (sometimes with 20 million+ records) and as you know it can be a nightmare... so if you have any alternate solutions I would love to hear them but I wasn't able to find any.
