Expression help

[hopkinsc]

hi,

I am trying to write an expression and need some help.

I have a dimension of 'Month'

and i need to count 'Offline ID' where 'Offline Date' falls within each month.

Can anyone help please?

[hic]

You should create the "Month" from the "Offline Date" already in the script. Then the count will easily be displayed in a chart with Month as dimension and Count(distinct [Offline ID]) as expression.

HIC

[#3]

Are these two tables joined?

Maybe you should join them using IntervalMatch()?

[#4]

IF(not Isnull(Offline Date),count (Offline ID))

[#5]

Use Henrics suggestion. Applying the transformation in script will have performance benefits for you in the front-end. As he stated, the expression then is very simple