New to Tableau and just found out you can't "create group" on dates if your using a cube. Does anyone know an alternative? I want to create a Pre vs. Post Event and compare. I've done this using a sql table and it works fine but from a cube it is not an option.
Any help would be greatly appreciated.
It sounds like you could create a calculated field to categorize your records.
Is your date fixed, or do you want the user to be able to choose the date?
In the fixed case, you would make a field like such:
IF [RecordDate] < #7/1/2012#
THEN 'Pre-July 1'
ELSE 'Post-July 1'
If you want, you could replace #7/1/2012# with a Parameter (date data type) and let the user set the date.
Does this help?