Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Are these two tables joined?
Maybe you should join them using IntervalMatch()?
IF(not Isnull(Offline Date),count (Offline ID))
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