Eg. For a particular category I am expecting a cumulative total on next time the same category appears on view but in actual getting an entry related to that date only.
Attached is the sample workbook for reference
This issue is related to the order of operations in Tableau. Table calculations are computed after dimension filters. The built-in viz in tooltip filter is a dimension filter. To fix this problem we can
- edit the viz in tooltip script to remove all filters
- create sets for any fields that should filter the viz in tooltip worksheet https://help.tableau.com/v10.4/pro/desktop/en-us/sortgroup_sets.html
- Creating a table calculation filter that filters the viz in tooltip worksheet by the sets. For more explanation why/how see Filtering the View Without Filtering Underlying Data
- Create set actions that update the values in the set based on what the user is hovering over. See https://help.tableau.com/current/pro/desktop/en-us/actions_sets.htm
Note, you may see some lag as you hover over different items because two set actions have to run before the tooltip will be updated. You may consider using the Select trigger rather than the Hover trigger and instructing users to click to see the tooltip. This isn't faster, but it prevents the end using from seeing the data for the wrong row.
Sorry for the weird formatting. The new forum doesn't have any formatting options
Hope this helps :)
What do you think of the new Community Forums? Let us know!
