How exactly does your date format look? Can you give some examples? Any chance of getting some sample data or a packaged workbook? If confidential, can you just make up a bit of data?
When I apply a MDY filter to the rows my date is filtered as something like August 11th, 1990 however on my data sheet is imported from excel and the data is formatted as 8/11/1990. If you would like me to make up some data please let me know! I really appreciate the help.
1 of 1 people found this helpful
I created a sample data set in Excel (attached). In Tableau, I then created an Age calculated field with the following formula:
IF [Birthday]>DATEADD('year',-DATEDIFF('year',[Birthday],TODAY()),TODAY()) THEN
Then, using this, you can create a histogram and set the bin size to whatever you like. In the attached workbook, I've set the bin size to 10.
If this helps to address your question, please be sure to mark this answer as helpful or as the "correct answer". This will help others who may have similar questions in the future. Thanks!!
I am still having trouble with Age and getting it to create bins. For some reason after I have added age as a measure with the formula you have used when I left click to create, bins, bins doesn't show up. Do you know if I'm missing a step?
I really appreciate you setting up and example!
Never mind Ken I have resolved it! thank you for all of your assistance, I really appreciate it!
Michaela, would you mind sharing the resolution to your problem, then marking your answer as the "correct answer"? This will help others who may have similar problems in the future. Thanks!