Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I am looking to do set analysis where two different date fields have the same value.
Essentially, I have a data model where I have two calendars, A, B. What I need to display in my chart is the sum of some fields from Table B and the Sum of fields from Table A, all having the dimensions of Table A.
Table A: TableB:
CasesCreated ProjectedAmount
CreateDate BudgetDate
The set expression I am trying to build is
Sum({<CreateDate = BudgetDate>} ProjectedAmount)
Ideally, this expression would return the total Projected amount where the dates are equal.
Any thoughts?
I have already tried using the above and with p() to no avail.
Thanks!
You can do an if statement with a calculated dimension and then you don't need set analysis in your expressions at all. Oleg is right though it would be a Cartesian join that may not perform very well if you have a lot of data.
But your calculated dimension would be something like:
if (CreateDate=BudgetDate,CreateDate,'')
Then you can create your expressions normally as sum(ProjectedAmount) or whatever it may be.