Hey Analytics friends,
I know the answer is probably no, but has anyone figured out a way to combine 2 cube's data in a single widget (I.e plans and contributions)
The below widget is from the contribution widget.
But boss wants me to add in a PLAN ASKS TOTAL column to the same pivot table to compare to the raised amount.
Additionally he wants a column with the delta of Funds raised, so I'll write a simple formula.
Any insight is appreciated!
Happy New Year!
-Brian
We have a very similar need to compare recorded contributions against plans data that assists in forecasting for the year and my understanding is that it would be something we would have to request as a customization from consulting (unless perhaps of course you have someone sql savvy enough on site). We went through a successful consultation process to combine data needed from the contributions cube and the finance cube for a monthly report I need. Looking forward to a future in which the cubes can better communicate data with each other!