Hi, all-
Working on a dashboard and I'm trying to compare what percent to goal each campaign is at with a year-over-year comparison. I would like to include the current FY, as well as the last two FYs in the same point in time. I'll be doing the same for our ticketing side, too.
I have figured out this year's percent to goal for each campaign, but am trying to figure out the prior FY(s) portion...
Has anyone done this already, or does anyone have suggestions on how to do this?
Thanks in advance!
Rachel
I've struggled to do percentages-over-time graphs as well.
Working in the Plans cube, my starting point would be to do a line chart with Calendar Month Sort on the X-Axis, and a formula of [Total Contribution Amount] / [Total Goal Amount] on values, with Fiscal Current Year Offset on the break by.
Thanks, Tim! I'll have to look into this. Appreciate your suggestion.