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;IF(RecordSent="","",IF(RecordReturned="",((NETWORKDAYS(RecordSent,TODAY()))-1),((NETWORKDAYS(RecordSent+1,RecordReturned)))-1))
RecordSent and RecordReturned are date dimensions.
I tried ( [RecordReturned] - [RecordSent] ), but that's not working right.
How can I recreate this formula on Tableau?
Try the following formula:
datediff('day', [RecordReturned], [RecordSent])
Hope this helps!
For just workdays, you may find some hints here: http://community.tableau.com/thread/104481
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...