Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please refer the table below:
I want an expression to count number if all the values design_accept=3.
Eg; If all the values for design_accept=3 for each MachDateKey then it should count as 1.
Please assist.
Assume I have two data sets 'X' and 'Y' of two different weeks.
X being the current week and Y being the previous week which had Date field storing two different dates.
I have declared two variables vMaxDate=Max(Date) and vMinDate=Min(Date).
I want to use these variables in the above set analysis expression for counting the same field.
What modifications should I do to the above set analysis expressions given as correct for this post ?
For this expression : Count({<MachDateKey = {"=design_accept = 3"}>} DISTINCT MachDateKey)
Assume I have ...
Sample works much better then Assuming
This expression is working weird for me.
It's giving the correct output at one point and then again when I reload new data, it's giving wrong output.
I am unable to follow the syntax of this set analysis expression.
Please assist.
Can you provide a sample to show where this isn't working?