Modify Dimension

[robert_mika]

This is maybe obvious but is is possible instead of creating Calculated Dimension change an existing one "on fly"

To Example:

If I had Dimension "Dates"

1/1/2012

2/2/2013

.

.

Create :

Year(Dates)

So my Expression will read:

IF(Year(Dates)='2013'

or COUNT(${<Year(Dates)={'2013'}....

[sujeetsingh]

You can use the calculated dimension.

Well i do not think you can create any value in UI.

You can achieve this in script.

you can have master calender concept.

Follow this

Creating A Master Calendar

[#3]

You can't modify a field on the fly. That needs to be done on the script, which is the recommended way.

Just create it on the script like: "Year(Dates) as Year" and then you can use COUNT(${<Year={'2013'} Field).

If by any reason you can only do it on the front end, then you can create a variable, let's say vYear, define it to be "=Year(Dates)" and then you can use COUNT(${<$(vYear)={'2013'} Field).

Or, without creating anything, you can still use COUNT(${<$(=Year(Dates))={'2013'} Field), on the fly.

But like I said, it's better to have all necessary fields created in the script.

Hope this helps.

Kind regards,

Nuno