Why isn't it working? Are you getting an error? Is your data wrong?
You will need to provide more details and a Tableau Packaged Workbook including some sample data.
Thank you for helping me. I attached the workbook. The calculated field I created is called "Date Range". I dragged Date Range to either Columns or Color. Both showed NULL. I would appreciate it if you could take a look at it.
Academic Year_Tab.twbx 311.8 KB
The only thing to add is a single quotation mark (') inside the date brackets.
This worked for us.
If [Date]>=DATE('7/1/2014')AND [Date]<=DATE('6/30/2015') THEN '2014-2015'
ELSEIF [Date]>=DATE('7/1/2015') AND [Date]<=DATE('6/30/2016') THEN '2015-2016'
Let us know.
HI Jun Wu,
Please find the attached screenshot. This field should be dynamic in nature. You have wrote dates in the calculated fields. If you use it you will have to update that calculated filed every Academic fin year. Below calc will solve your problem. Attaching tableau workbook 9.3 as well as excel data that I have used. You can use it along with day granurality as well.
FY Academic Year
if MONTH([Dates])>=7 and MONTH([Dates])<=12 THEN str(YEAR([Dates]))+"-"+STR(YEAR([Dates])+1)
elseif MONTH([Dates])>=1 and MONTH([Dates])<=6 THEN str(YEAR([Dates])-1)+"-"+STR(YEAR([Dates]))
Let me know if this helps.
Thanks and Regards,
Thanks Chris! It works! I appreciate your help!
This is awesome!! Thanks so much for helping me on this. I appreciate it.