• Replies 8 replies
  • Subscribers 701 subscribers
  • Views 268 views
  • Users 0 members are here
Options
Related

Hard-coded goals and formulas

Odele Peter
$organization

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

Parents
  • $organization

    I was able to use this, modify it, and look at max allocations for certain zones, weekdays vs weekends:

    CASE

    WHEN( [Max Zone Group Rank]) = 7 AND ([Max Day Of Week]) = 1 THEN 920
    WHEN( [Max Zone Group Rank]) = 7 AND ([Max Day Of Week]) = 2 THEN 755
    WHEN( [Max Zone Group Rank]) = 7 AND ([Max Day Of Week]) = 3 THEN 755
    WHEN( [Max Zone Group Rank]) = 7 AND ([Max Day Of Week]) = 4 THEN 755
    WHEN( [Max Zone Group Rank]) = 7 AND ([Max Day Of Week]) = 5 THEN 755
    WHEN( [Max Zone Group Rank]) = 7 AND ([Max Day Of Week]) = 6 THEN 755
    WHEN( [Max Zone Group Rank]) = 7 AND ([Max Day Of Week]) = 7 THEN 920

    WHEN( [Max Zone Group Rank]) = 8 AND ([Max Day Of Week]) = 1 THEN 1840
    WHEN( [Max Zone Group Rank]) = 8 AND ([Max Day Of Week]) = 2 THEN 1580
    WHEN( [Max Zone Group Rank]) = 8 AND ([Max Day Of Week]) = 3 THEN 1580
    WHEN( [Max Zone Group Rank]) = 8 AND ([Max Day Of Week]) = 4 THEN 1580
    WHEN( [Max Zone Group Rank]) = 8 AND ([Max Day Of Week]) = 5 THEN 1580
    WHEN( [Max Zone Group Rank]) = 8 AND ([Max Day Of Week]) = 6 THEN 1580
    WHEN( [Max Zone Group Rank]) = 8 AND ([Max Day Of Week]) = 7 THEN 1840

    END

    Basically, weekENDs have different allocations (in this case General Admission tickets) than weekDAYs, and the 3-4pm zone is different than the 4-6pm zone.

Reply
  • $organization

    I was able to use this, modify it, and look at max allocations for certain zones, weekdays vs weekends:

    CASE

    WHEN( [Max Zone Group Rank]) = 7 AND ([Max Day Of Week]) = 1 THEN 920
    WHEN( [Max Zone Group Rank]) = 7 AND ([Max Day Of Week]) = 2 THEN 755
    WHEN( [Max Zone Group Rank]) = 7 AND ([Max Day Of Week]) = 3 THEN 755
    WHEN( [Max Zone Group Rank]) = 7 AND ([Max Day Of Week]) = 4 THEN 755
    WHEN( [Max Zone Group Rank]) = 7 AND ([Max Day Of Week]) = 5 THEN 755
    WHEN( [Max Zone Group Rank]) = 7 AND ([Max Day Of Week]) = 6 THEN 755
    WHEN( [Max Zone Group Rank]) = 7 AND ([Max Day Of Week]) = 7 THEN 920

    WHEN( [Max Zone Group Rank]) = 8 AND ([Max Day Of Week]) = 1 THEN 1840
    WHEN( [Max Zone Group Rank]) = 8 AND ([Max Day Of Week]) = 2 THEN 1580
    WHEN( [Max Zone Group Rank]) = 8 AND ([Max Day Of Week]) = 3 THEN 1580
    WHEN( [Max Zone Group Rank]) = 8 AND ([Max Day Of Week]) = 4 THEN 1580
    WHEN( [Max Zone Group Rank]) = 8 AND ([Max Day Of Week]) = 5 THEN 1580
    WHEN( [Max Zone Group Rank]) = 8 AND ([Max Day Of Week]) = 6 THEN 1580
    WHEN( [Max Zone Group Rank]) = 8 AND ([Max Day Of Week]) = 7 THEN 1840

    END

    Basically, weekENDs have different allocations (in this case General Admission tickets) than weekDAYs, and the 3-4pm zone is different than the 4-6pm zone.

Children
No Data