Hi folks, I've been asked to build a Contributions (running sum of Amount) to compare campaigns Year on Year. That's easy enough but the Dev folks would like to do that using Transaction Date. From my understanding in order to compare I'd need either a Transaction Date Since Campaign Start (as with Contribution Date Since to Campaign Start) but that neither exists nor is there anyway to calculate in the X axis.
Is this a no go? or has someone worked around this kind of thing
Heath Wilder
You have not said which ecube you are using. Are you trying to do this in the contribution cube or the Finance Cube? (As far as I know, Transaction dates are only in the finance cube.)
The original was built using Contributions Cube. I've moved it to the Finance Cube to get the Transaction Date BUT Transaction Date Since Campaign Start doesn't exist
Can you do a date difference calculation with a hardcoded campaign Start date in your formula? (I know pain, particularly managing this over several campaigns and several years.)
This might make a nice feature request.
not on the X axis (as far as I'm aware of). That's a great idea though and what I used to (pull in excel pivots)