Hi - following up on today's topic about hard-coding goals in a widget. We recently had a package that was set up as one event and it had separate goals for each price zone group. I created a widget that summarized sales by price zone group and needed to hard-code package # goals and % rev to sales goal. The key was to find something that distinguishes each row - in this case, the zone group rank. I will say ... I wouldn't share this widget with staff since the hard-coding is hidden in the formulas and therefore results are inaccurate when widget/dashboard filters are changed. But I did share it as a report to staff.
The goal uses the rank of each zone group to distinguish each row:
And the % to rev goal is similarly:
Odele
Oh interesting. I haven't seen this done before and will have to try it out. How are you getting the % to rev goal to show as a bar?
Data bars are a Values feature in the hamburger dropdown
Ooh thanks, Heath! p.s. I just found your availability dash in the forums and have been fixing it up for our uses for dynamic pricing decisions. Thanks for sharing (3 years ago)
OH great. Let me know how you go. It's an early effort and I'd love to find out about your upgrades.