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 |
| | | | | | | | | |
| | | | | | | | |
| | | | | | | | |
|
