Could you post a small sample set of data and your desired outcome? I don't fully understand what it is you are looking for.
1 of 1 people found this helpful
You can create discrete measures and use those to generate headers, and table calculations can partition on discrete measures (by turning off Ignore in Table Calculations), but like Daniel I'm not clear on your goal. Posting a packaged workbook or using Superstore Sales to model it would be useful.
I want to use an aggregate measure as a filter, or compare other measures without summarizing in the data source.
For example, I would like to compare levels of absences (let's say 1-10 absences, 11-20, etc) to number of discipline incidents. Or perhaps filter on the sum of absences.
I can summarize the values in the data source so was only asking to see if there are any other options. Not critical at all, so no packaged workbook... Appreciate the tip, Jonathan.
You can do something like the following:
IF SUM(absences) > 20 THEN 'Terrible Attendance'
ELSEIF Sum(absences) > 10 THEN 'Poor Attendance'
ELSE 'Fair Attendance'
Which is similar to a bin and, which you could use as a filter and compare to discipline incidents...
Hope this helps!
Daniel, that calc can't be used as a filter because it's a discrete regular aggregate. This is a limitation of Tableau, it does not compute the domain of discrete aggregates for use in Quick Filters. There are a couple of workarounds:
- Convert the calc into returning continuous dates
- Use a table calculation (which Tableau can compute the domain for).
I set an example up using Superstore Sales in the attached.
discrete measure filter demo.twbx.zip 1,011.6 KB
Thanks again, Jonathan! And appreciate your responses Daniel, keep it up. These forums only get better with more participation.
Thanks, Matthew and Jonathan. I've learned a lot from this one!