• Replies 4 replies
  • Subscribers 961 subscribers
  • Views 194 views
  • Users 0 members are here
Related

Yesterday's sales columns

Terry Stevens
$organization

I have a widget that shows performance total ticket paid count, total ticket paid amount, budget amount, budget to go, total seat unsold count and avg ticket price.  I would like to add two more columns, yesterday's ticket paid count and yesterday's ticket paid amount.  In other words yesterdays sales numbers.  Is there a way to do this using a formula in the value for Ticket Paid Count and Ticket Paid Amount?  

Parents
  • $organization

    Hi Terry.  Try this ...

    1. add a Value column for yesterdays takings  
    2. I'm going to use Total Ticket Paid Amount but you can do the same for # tickets
    3. Edit the formula and add a filter (sum([Ticket  Paid  Amount]) , [FILTER HERE]  )
    4. The Filter I'll use Order Date - Date

              5. RT Click and filter that [Year in Date]

              6. Choose DAYS and TIME FRAME then choose YESTERDAY

    Remember the whole function should be in brackets like (sum ( [Ticket  Paid  Amount]) , [Days in Date] )

    That should do it.  It looks OK here but our Analytics is playing up so I can't check it 100%

    Hope that helps

    Heath

Reply
  • $organization

    Hi Terry.  Try this ...

    1. add a Value column for yesterdays takings  
    2. I'm going to use Total Ticket Paid Amount but you can do the same for # tickets
    3. Edit the formula and add a filter (sum([Ticket  Paid  Amount]) , [FILTER HERE]  )
    4. The Filter I'll use Order Date - Date

              5. RT Click and filter that [Year in Date]

              6. Choose DAYS and TIME FRAME then choose YESTERDAY

    Remember the whole function should be in brackets like (sum ( [Ticket  Paid  Amount]) , [Days in Date] )

    That should do it.  It looks OK here but our Analytics is playing up so I can't check it 100%

    Hope that helps

    Heath

Children
  • $organization in reply to Heath Wilder

    Heath you are amazing!  I also was pretty sure you would be the one to help because I was working so late, thank you!  I have a couple more questions.  What do I need to add to the formula to show zeros for those that have had no sales?    I am so close to getting this report looking perfect thanks to you.   The only thing I'm still missing is to show our ticket count budget numbers for each production.  Is there a custom area in Production or Performance where I can add ticket count budget numbers and then pull that into the dashboard?  

  • $organization in reply to Terry Stevens

    Hey Terry.

    No problem. It was a fun discovery for me too. I just finished my Friday night D&D game but when i get to work in the morning I'll have a play around. I think there is an IF NULL function in there than I've been meaning to look at. That might do it. 

    Cheers

    H

  • $organization in reply to Heath Wilder

    Hi Terry,

    Me again ... Try this little conditional formula.  It's my first ever but it seems to work.

    IF ( ISNULL ( sum ([Ticket  Value]) ) , 0 ,  sum ([Ticket  Value]) )