Calculated Dimenstion

[penpayom]

Hi All,

I want to Create List Box (Month/Week),

When i Click Month ,Dimension In chart  must show Data by Month ,

 When i Click week  ,Dimension In chart  must show Data by week

[shiveshsingh]

What does MONTH signify here? Is it a dimension?

[shitijar]

Hi,

Try with the Below Expression: 

if(TYPE2='MONTH',MONTH&' '&WEEK)

Shetty

[PradeepReddy]

The calculated dimension showing error, because there is no fields 'Month' or 'Week' in your data model.
First create Month & Week Fields in your script like this(check the creation_date format)...
Month(Creation_Date) as Month,
WeekName(Creation_Date) as Year_Week

now create a calculated dimension like this...
IF(TYPE2='MONTH', Month,Year_Week)