1 Reply Latest reply on Feb 24, 2016 5:09 PM by patrick.byrne.0

    Associated Values during certain times in a day

    mike.e

      Hello, I was hoping someone can help me. I am trying to identify as a percentage what is the total number of venue tickets available versus tickets sold on 2/4/2016 from 8:00:00AM until 3:00:00PM. The next calculated field would be a running total of number of tickets available versus sold on the same day but this time from 8:00:00 AM until 4:00:00 PM. My field for tracking venue tickets received is stored as date time 2/4/2016 8:00:00 AM (same for format for tickets sold). My initial thought was creating a parameter for each time range or a calculated field, however I am having trouble coming up with an efficient approach.

      Thanks in advance