1 of 1 people found this helpful
First of all, to share sensitive data, anonymize your workbook:
That's a 10-minute video that demos how to anonymize.
As for your specific question, you're going to have to re-shape your data one way or another to give Tableau a date dimension. And it's not going to be as easy as simply converting things. You'll need one row per time period per company per account.
Took your advice and reshaped everything. It took some time but it works now, I added a date value per row, per company, per account and now Tableau sees it properly. Also, thanks for the Tableau anonymizing video, it helped a lot. In the meantime, I also discovered this service: Mockaroo - Random Data Generator | CSV / JSON / SQL / Excel. Works really well. It generates data like email addresses, names, and numbers.
This is what my sheet looks like with proper dates:
Having your data shaped that way gives you a lot more power to display and analyze it.