Morning all,
Ok so I have a question - How am I supposed to aggregate my data so that it is most efficient in my viz? Right now it is slow, slow, slow and I believe it has to do with a LOD expression and too many ATTR that I am using. In case your wondering - yes, I did extract my data!
What I am most interested in for this data set is the period of performance information which is the version number, start and end dates. Any financial information can be pulled from a different table though a join. But I think the financial information is part of the problem why I can't see the data at the row level that I want because every time there is a transaction against a contract number, it creates a new row in the table.
I have tried to use 3 LOD expressions at once to achieve the max version number, min start date, max start date. That works but the performance in a dashboard is slow. I have also tried a calculated field to show the max and mins and that works but when I blend that data with the financial data, the filters don't connect across the data sources.
I have also tried to pull multiple occurrences of the same table via a customSQL statement "SELECT DISTINCT CONTRACT NUMBER...". That works but I am not sure I have the joins correct to do what I want.
I was watching a YouTube Video on shaping data. I think if I made a couple of custom views I can make this work. The problem is that I don't know how to do this at the data source level.
- So if I pull data in to the following data source:
- Data Source #1: Select distinct of the contract number,
- Data Source #2: Select distinct of the contact number with the max and min date.
Attached is a made up sample of my source data. If this is what your source data was, what would you do?
I am using Tableau version 10.5
Thank you in advance for your help!
Scott
