Each of those calculations are 'hard coded', meaning they're being used for a very specific condition. Is there a reason that filters cannot be used with each subsequent one then using 'Only Relevant Values' to further define what's available to the user in terms of available data and end-results?
That might be a better approach than using specific calcs for each customer? Just a thought...thx, Don
My initial thought was filters, but I couldn't seem to find a way to filter my information down to the level wanted.
For instance, customer 2 wants the total fares from: Bus ID 2, Stop Name Starbucks, and Stop Name Costco. But when I filter by Bus Id, and mark Bus ID 2, then all other stops not included in Bus ID 2 gets removed, namely Starbucks.
So if there is a way to filter by: Bus ID or Stop ID or Stop Name (where there isn't always overlap), it would be great.
Hope this makes sense.
Then you're really looking at having to hard-code those scenarios in for each customer.
Alternatively, you could bring in customer ID or customer name to help you along, and then perhaps develop out a parameter for each customer, that is if all Customers are okay with seeing other Customers results...Customer A would see Customer B's results and vice-versa.
Your Parameter Filter would still be hard-coded for each customer's requirements however because of the desired overlap in criteria. You can't currently multi-select items in Parameters such as Stop 1 and Stop 2, so you'll still need some calcs with multiple criteria to get where you need to be. Tableau is great at producing results, you'll just need to instruct it as to what...
You should be able to add those dimensions as filters then right click the pills in the filter pane, there should be an option that says “show filter”. select that and you will see thone filters appear on the right side of the screen. Click the arrow above the filter and you can change the way you can select from the filter itself. There should be an option for select multiple items that allows the user you simply check a box for the buses and routes they wish to see.