Drilldown in a histogram

[mr_novice]

Hi All,

I have a very simple histogram with a drill down dimension (or group) consisting of two fields - YearMonth and Date. The group is called "DrillDownDim". My expression is sum(sales)/count(distinct Date). This works fine. What I want to do is change the title in chart depending on the level of DrillDownDim. I would like to do something like this: "if (DrillDownDim = "YearMonth", 'This is Monthly', 'This is daily'). How can accomplish this?

[hector_munoz · Accepted solution]

Hi Cristian,

Take a look at GetCurrentField() function.

Regards,
H

[mr_novice]

Gracias/Thanks Hector!

Didnt think about the GetCurrentField()-function. I did this "if (getcurrentfield(DrillDownDim) = "YearMonth", 'This is Monthly', 'This is daily').

Works perfect!

[hector_munoz]

Fantastic!