Hi tableau comm!
You guys are super awesome, so I figured this is a great place to pose my query.
I'm attempting to restructure this "database" that my purchasing department currently utilizes - it's about 485,000 rows within an Excel file of all possible freight (truck and rail) rates for different products, from vendor to customer. This takes almost five minutes to open, and about forty-five seconds to filter any column... so yeah, I'm wanting to steer them AWAY from ancient tech. I've to date taken all the appropriate list files of data, joined and cleaned them within Prep, and have a flow created for tableau.
My concerns lie within the simple fact that they love tables, filters, dialing in to a few rows of numbers. They filter like five different columns.
I would LOVE to shape a simple dashboard so they can hone in on specific vendor freight pricing for products to various customers, or vice versa- various vendor's pricing to one specific customer.
I could make simple sets or parameters for Vendors, Customers, and Products...but there are multiple vendors within one city, and then also multiple vendor locations- same name, different cities (at least the customers are more individualistic.) It will indeed become quite confusing in a short matter of time, and thinking of LOD expressions for it is hurting my brain.
Would filters, atop of a different filter, inside and outside of a filter, parameter, set, etc., the best way to approach something like this? Renaming all the vendors to where the city location is included, and making them unique values? I was trying to avoid editing the entire vendor list (ex: company is "Sugar Mountain," not "Sugar Mountain - Lafayette, CO.") Do I make a Top N set for least expensive freight options, instead of them filtering x, y, and z, until there's like two lines remaining? That seems excessive.
Not many examples of a table-type dashboard out there, since tableau is primarily used to demonstrate data within graphics and colour. I concur that a pretty dashboard is awesome and most desirable, but I need to make something that they're going to use immediately.