1 of 1 people found this helpful
you can use the Date function to create constant dates.
then you can create a Groups dimension with
if [17Sept2014] <= [Date] and [Date] >= [16Sept2015] then "Group A"
elseif ..... then "Group B"
Next by bringing the Groups dimension in the view, you can simply to a COUNTD(Persons) on every marks
You leave the final Groups dimension a string, rather than switching to a date dimension, correct?
Exactly, see it as the creation of a new column in the dataset where every row have a Group X value depending on the date.
Thanks for the tips, Michel. I ended up creating a table of start & end dates, so I wouldn't have to DATE code all of them within Tableau as individual dimensions. But your grouping suggestion based on range is a good one. Thanks again!