This content has been marked as final.
Show 1 reply
-
1. Re: Chart for Monthly closure rate
Yuriy FalMar 6, 2016 2:54 PM (in response to Deborah Auer)
Hi Deborah,
Your datasource is of a kind called
Accumulating Snapshot, or Lookup.
A great intro into a Lookup vs Transactional data type is here:
http://redheadedstepdata.io/lookup-vs-transactional/
To come to the results you want,
one would need to transform data
into another common type called
Periodic Snapshot.
This could be done in Tableau one way or another.
My favorite one is using data blending into a Scaffold datasource.
Please find the attached workbook & Scaffold DS.
Hope it could help.
Yours,
Yuri
-
Scaffold.csv.zip 146 bytes
-
Book1_YF.twbx 475.4 KB
-