This content has been marked as final. Show 2 replies
I'm having trouble creating a calculated field to measure Average Number of workdays to close a record.
We interpret this by taking the date the record was sent to us and counting the number of workdays it took to close it.
This is the excel formula we currently use;
RecordSent and RecordReturned are date dimensions.
I tried ( [RecordReturned] - [RecordSent] ), but that's not working right.
How can I recreate this formula on Tableau?