calendar as data island

[m_woolf]

I'm reposting this because I thought it was solved and marked it as Answered. Now the original discussion is locked.

I have a master calendar that is not linked to nay other table.

In my expression, I use something like:  =sum(if(field1 = calendar_field1,field_to_sum))

This works, but I believe that if I could replace it with set analysis it would be faster.

Any help?

Andy Weir replied:

Andy Weir Sep 3, 2015 3:17 PM (in response to M Woolf)

UM({$ <[field1]=p([calendar_field1])>} field_to_sum) should work

I found that this works in a text box when I select some calendar dates, but it does not work in a chart with calendar date as the dimension. It looks like it doesn't aggregate by the dimension. I tried adding aggr to my expression, but no joy.

[alexandros17]

But what is the use of a calendar unlinked to other dates?

[m_woolf]

Suppose I have 6 different charts. Each is based on a different date field.

I can use: =sum(if(field1 = calendar_field1,field_to_sum))

as the expression for each chart where field1 is a different date field for each chart. The same calendar can be use to filter all the charts.