I am new to tableu (just downloaded the free trial) and I am trying to build a software license flow sankey diagram. I am quite fond of excel but I would like to visualize a license flow over all contracts over several years of usage, starting with Products (or Product Family) and then moving from contract to contract.
This is a simplified spreadsheet view.
|Product||Family||Contract #||Initial Oder||Additional new order||License Count Total||Licenses for renewal||License not renewed||Renewal Contract #||Contract end date|
|OfficeStd ALNG SA MVL||Office||123456||100||12||112||90||22||123456a||31.12.2006|
|Windows Professional All Languages SA MVL||Windows||123456||350||0||350||350||0||123456a||31.12.2006|
|OfficeProPlus ALNG SA MVL||Office||123456||250||10||260||240||20||123456a||31.12.2006|
|CoreCAL ALNG SA MVL DvcCAL||Core CAL||123456||350||20||370||350||20||123456a||31.12.2006|
|SQLCAL ALNG SA MVL UsrCAL||SQL CAL||123456||350||10||360||300||60||123456a||31.12.2006|
|MSDNUnvrsl Win32 ALNG LicSAPk MVL||VS||123456||10||2||12||10||2||123456a||31.12.2006|
|ExchgSvrStd ALNG LicSAPk MVL||Exchange||123456||1||0||1||0||1||123456a||31.12.2006|
|SharePointSvr ALNG LicSAPk MVL||Sharepoint||123456||1||0||1||1||0||123456a||31.12.2006|
|OfficeStd ALNG SA MVL||Office||123456a||90||0||90||90||0||123456b||31.12.2009|
|Windows Professional All Languages SA MVL||Windows||123456a||350||10||360||355||5||123456b||31.12.2009|
|OfficeProPlus ALNG SA MVL||Office||123456a||240||20||260||260||0||123456b||31.12.2009|
|CoreCAL ALNG SA MVL DvcCAL||Core CAL||123456a||350||50||400||400||0||123456b||31.12.2009|
|SQLCAL ALNG SA MVL UsrCAL||SQL CAL||123456a||300||1||301||300||1||123456b||31.12.2009|
|MSDNUnvrsl Win32 ALNG LicSAPk MVL||VS||123456a||10||1||11||9||2||123456b||31.12.2009|
|ExchgSvrStd ALNG LicSAPk MVL||Exchange||123456a||0||1||1||1||0||123456b||31.12.2009|
|SharePointSvr ALNG LicSAPk MVL||Sharepoint||123456a||1||0||1||1||0||123456b||31.12.2009|
|OfficeStd ALNG SA MVL||Office||123456b||90||10||100||100||0||123456c||31.12.2012|
|Windows Professional All Languages SA MVL||Windows||123456b||355||0||355||355||0||123456c||31.12.2012|
|OfficeProPlus ALNG SA MVL||Office||123456b||260||0||260||260||0||123456c||31.12.2012|
|CoreCAL ALNG SA MVL DvcCAL||Core CAL||123456b||400||1||401||400||1||123456c||31.12.2012|
|SQLCAL ALNG SA MVL UsrCAL||SQL CAL||123456b||300||5||305||300||5||123456c||31.12.2012|
|MSDNUnvrsl Win32 ALNG LicSAPk MVL||VS||123456b||9||0||9||9||0||123456c||31.12.2012|
|ExchgSvrStd ALNG LicSAPk MVL||Exchange||123456b||1||1||2||1||1||123456c||31.12.2012|
|SharePointSvr ALNG LicSAPk MVL||Sharepoint||123456b||1||5||6||1||5||123456c||31.12.2012|
This is basically 3 contracts: 123456 - 123456a - 123456b, ending with licenses transferred to the last (here missing) contract 123456c.
Every contract consists of products (in this example it´s always the same products - the filled spreadsheet will introduce new products aswell), and initial order (which is usually the total number of licenses renewed from the prior contract, additional new order licenses and the amount of licenses that were marked for renewal.
What I like to show is a sankey diagram that has the individual products as rows and every single contract number as columns, however, the individual licenses should be identifiable. So, a flow from products to contracts and after that only % of licenses moving from contract to contract is not enough.
Basically it is this view with additional nodes (contract after contract). This was done in PowerBi - but it only works for 1 single contract, I can not link several contracts to show a license flow. Also, I would need to show newly added licenes, timed at the beginning of each contract number, at well as licenses not renwed moving out at the beginning of each new contract (endpoint of old contract).
Is this doable? If so - can anyone guide me how this can be done? From what I understand it should be possible to do with 2 tables linked - I tried a few things from that post https://community.tableau.com/thread/152115 because this looks very promising, but I failed.
Thanks in advance for any help!