Thanks for your reply. Didn't know of the FIXED function before now
But It doesn't seem to solve the problem as completely;
* the count of solved cases doubles the count of cases
* and solved cases are listed on the created date, should be listed on the solved date.
There was a minor flaw in my data (last few rows had a created date later than the solved date.)
Another way would be to show the same measure count (cases) on the two time dimensions (created and solved date) in a dual axes, but I cant get that working in Tableau...
Two dimensions.xlsx 9.2 KB
You've solved the main problem Thanks.