Nested if Statement to create Sub-Fields from my Date Field
I'm a bit stuck on a small problem I have and any suggestions would be much appreciated......
I have a Date field 'Invoice_Date' being used as a dimension in a bar chart.
I would like to group these invoices into 6 catagories Based on their due date, ie. whether the invoice is due at some point in the future or at some point in the past. These catagories would be relative to today 'today()'
The categories would be as follows:
Invoice due in 15 days +
Invoice due in 8-14 days
Invoice due in 0-7 days
Invoice overdue 1-7 days
Invoice overdue 8-14 days
Invoice overdue 15 days +
I gather I need a calculated dimension made of a chain of 'if' statements but cant quite get it to work.