• Replies 7 replies
  • Subscribers 962 subscribers
  • Views 112 views
  • Users 0 members are here
Related

Festival Daily Report Dashboard

Iain Shand
$organization

Hi all,

Trying to convert a big excel with multiple tabs into a dashboard so it is easier to maintain during the festival period.

Have managed some of it but struggling with a few areas so any help would be appreciated.

1. I have a table created showing our highest revenue events and another showing our lowest, how do I tidy it up so it only shows the top or bottom 10 and not every single event?

2. I need to show the amount gained from our booking fee's during the festival. Is this possible? I put the fees into the Ticketing Setup and have created the Fee rules so it will apply to the correct events.

3. I need to create a table that shows every event with their daily movement in ticket sales/$ revenue and their cumulative movement over the course of our on sale period.

4. Finally, I have created a bar chart that shows the total revenue of previous festivals and has the new festival lined up next to it, is it possible to adapt this so it goes up day by day across all years? A Matching sales day comparision with $ revenue across the past 5 or so years.

Understand that is a lot but any help here would be appreciated. Would make my life easier during the festival!

Thanks,

Iain 

Parents
  • $organization

    Hi Iain
    I can help with some of this.

    1. On the 'Value' element in the left navigation select the funnel 'Filter' icon. The second option 'Ranking' has built in Top and Bottom functionality.
    There isnt a way to do the top 10 and bottom 10 together in a single widget so do two widgets with different filters.

    2. Fee revenue is actually recorded in the 'Finance' cube, not Seats and Tickets.
    Add a new Widget, then in the upper right change the Cube to SWFL Finance. Search for 'Fee' in Select Data - you should see the Fee types and Fee amounts. 

    Let me think some more on the others ...!
    Peter

Reply
  • $organization

    Hi Iain
    I can help with some of this.

    1. On the 'Value' element in the left navigation select the funnel 'Filter' icon. The second option 'Ranking' has built in Top and Bottom functionality.
    There isnt a way to do the top 10 and bottom 10 together in a single widget so do two widgets with different filters.

    2. Fee revenue is actually recorded in the 'Finance' cube, not Seats and Tickets.
    Add a new Widget, then in the upper right change the Cube to SWFL Finance. Search for 'Fee' in Select Data - you should see the Fee types and Fee amounts. 

    Let me think some more on the others ...!
    Peter

Children