I'd like to be able to add expenses to a widget on my dashboard, then from that, calculate net, based on income minus expenses - this is primarily aimed at direct mail income minus expenses = net..
I have added some costs on the 'Expenses' tab under Campaigns but I can't see how I then pull that into Analytics?
I do have both my contributions and finance data cubes attached to the dashboard. Any suggestion / has anyone a widget / dashboard to share?
Thank you!
Surely someone is adding expenses to dashboards? Anyone...?!!
You currently can't pull anything from the Expenses tab into Analytics. On the(Missing Group)call last week Greg from Des Moines Performing Arts shared how he was depicting some of this information via an IFrame Widget. This might be of some help to you.
That google sheets iframe pull was great
(Also I've added pugs singing Batman and smooth jazz to all my dashboards)
ooh, thank you...can you point me in the direction of any resources / further info on this?
Can you please share any resources / further info on these iframe(s) you speak of?!!
Hi Alisdair Sewell You can add an iframe widget by
It's pretty self explanatory from there. I recommend a holiday music playlist as your 1st iframe widget
Thank you - I got this working. Created a similar-looking table in excel, saved as JPG and then imported to iFrame - gives me static view, at least, of the monthly budget and the format matches that of the pivots in analytics - thank you!
You can do it in Google Sheets or SharePoint Excel and link it that way too. That way it's a little more dynamic. The only warning is that it has to be publicly visible as a link I believe so appropriate warnings there.
Thank you - all setup. Created spreadsheet in Google Sheets, which is dynamically linked to the dashboard in Analytics - when I make an update in the spreadsheet in Google, it automatically updates in Analytics 5 mins later - perfect and just what I needed. Thanks for all the help!