All - my first post. I am trying to add a calculated dimension to a chart. My goal is for each data point to represent 12 months.
For the field InvoiceDate, I can calculate the range I want with:
=if(month(InvoiceDate)=12,
makedate(year(InvoiceDate),month(InvoiceDate)-11) & ' to ' & makedate(year(InvoiceDate)+1,1),
makedate(year(InvoiceDate)-1,month(InvoiceDate)+1) & ' to BEFORE ' & makedate(year(InvoiceDate),month(InvoiceDate)+1))
This works sufficiently to 'see' the range I would get on a given date. But when I try to apply the general case using set analysis, I don't know how to properly format.
Here's what I have:
= if(month(InvoiceDate)=12,
{$<InvoiceDate= {">=$(=makedate(year(InvoiceDate),month(InvoiceDate)-11))<$(=makedate(year(InvoiceDate)+1,1))"}>},
{$<InvoiceDate={">=$(=makedate(year(InvoiceDate)-1,month(InvoiceDate)+1))<$(=makedate(year(InvoiceDate),month(InvoiceDate)+1)"}>}
)
I realize I'm trying to redefine Invoice Date (probably incorrect) but don't know what else to do. Thanks in advance,
Crabby!