Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following two tables Joined in the datamodel and I need to show the comparison between data for two date selections.
Lets say the dates are start and end date.
Requirement: 1.Report all the records that had passed on 01/06/2014 but failed on 22/06/2014
2. Find all records that have failed on 22/06/2014 but were not present on 01/06/2014
How can we achieve this?
may be i don't understand your question properly.. you can try below
=COUNT({<Result = {'PASS'}, DATE = {'01/06/2014'},KEY = P({1<Result = {'FAIL'},DATE = {'22/06/2014'}>}KEY)>}KEY)
and
=COUNT({<Result = {'FAIL'}, DATE = {'22/06/2014'},KEY = E({1<DATE = {'01/06/2014'}>}KEY)>}KEY)
it's possible.. provide sample data in excel format please.
Please find attached the xls
may be i don't understand your question properly.. you can try below
=COUNT({<Result = {'PASS'}, DATE = {'01/06/2014'},KEY = P({1<Result = {'FAIL'},DATE = {'22/06/2014'}>}KEY)>}KEY)
and
=COUNT({<Result = {'FAIL'}, DATE = {'22/06/2014'},KEY = E({1<DATE = {'01/06/2014'}>}KEY)>}KEY)
That was brilliant mate Thanks a ton