Can you post some sample data? A workbook would also help.
I'm sorry I cannot post a sample workbook, as this data is extremely sensitive. I was, however, able to find a work around by amending the query, but would like to know if there is a Tableau solution as well.
1 of 1 people found this helpful
Your inquiry is more than just a simple question. You are essentially in need of table calculations, which depend on the orientation and inclusion of dimensions in your view. Pretty much no one will be able/willing to guess the setup you have. To reiterate what Pedro said, you'd likely be best served if you could mock up some data that will create your situation.
As far as hunting for advice/tips, I've found no better source than Jonathan Drummey's blog: Drawing with Numbers | Thoughts on data visualization and Tableau. You can find a wealth of information by perusing the archives...
Thanks. I'll see what I can do with the data to get a sample loaded.
I have exactly the same question as Brett posted. I have attached a workbook that contains TXDuration for each ID. I need to aggregate this average to individual CPTCODE. I am fairly new to Tableau and i would greatly appreciate you help.
Sample Data.twbx 157.7 KB