Change_Date & Create_Date

[#1]

Hi,

Says i have a flat table, with Change date and Creation date of a row.

i need to create a table with month as dimension.
How can i let Change date /Creation date to fall into the right month in the table?

obviously i can't just use the month either from change / creation date.

[Miguel_Angel_Baeyens]

Hello Nick,

You will need two month fields, one for Change date, the other for Creation date, and you will use one of both as dimension depending on the analysis you want to return (select all items where change date falls into january or select all of them that where created in january).

You can let the user select the calendar and using variables to use a variable as dimension that stores the selection of the user.

Check this file and see if that helps.

Regards.

[sparur]

Hello Nick.

why you can't use like as:

month(Create_Date) as Month

or

month(Cange_Date) as Month

[brenner_martina]

Hi,

better you create a standallone calendertable with all Datefunctions you need, esp. startmonth and endmonth and in the expression you can use if-then-statements for aggregations:

Sum(If(startmonth<=Create_Date and Create_Date<=endmonth, sales, 0))

dito for Change_Date

Or set analysis ...