Two conditions on one Field in defined period

[#1]

Hello all,

I want to analyse a changelog, data like this:

count distinct [changes with "Change_Field Name" = "Branch" and "New Value" = 'meow' where there has been no change to "New Value" = 'woof' in period (date when last changed to 'meow') - 3 month until now.] over all values in key_field

This example:

result:

row 1 and 4 suffice condition1: change to "meow"

last change was at 18.02.2011 -> search for a change to "woof" from 18.11.2010 until now -> row 3 found

-> result is 0 for Key_Field "key123"

Would you aggregate the data in the script or can i do it with an expression in the dashboard (formula in table)?

Thanks in advance, Christian

Key_Field Date Entry No Change_Field Name Old Value New Value key123 07.02.2011 27642 Branch meow key123 07.02.2011 27644 ABC C key123 11.02.2011 30287 Branch meow woof meow 18.02.2011 32214 Branch woof meow