• Replies 13 replies
  • Subscribers 961 subscribers
  • Views 447 views
  • Users 0 members are here
Related

Labelled manual Data Points on Analytics

Jenna Whitnall
$organization

Hello all,

Just a quick one, I'm looking to try to plot a unique data point according to an x-axis or y-axis and then label it. A hypothetical example would be, I'd like to show a timeline of ticket sales with a marker showing when further COVID restrictions were announced, for example: 1 July-- COVID Restrictions announced. If the timeline was something like Perf Date, can anyone suggest an approach to try to achieve this?

Another example might be like "breakeven point" for ticket sales or something along those lines.

Grateful for any advice from any of you experts out there!

Jenna

Parents
  • $organization
    Hey Chris – this is awesome!
     
    How should the formula be hard coded if the X-Axis is ‘weeks in date’?
     
    JH.
     
  • $organization in reply to Jerry Hodgins

    Hi Jerry,

    If you still want to set a specific Date, and then have it annotate a given Week in Date, this is probably the most reliable approach: 

    For each date in the given x-axis week, see if that date is the desired annotation date, and if so, return a 1 to the Week. If the max value in any given week then is 1, render the RSUM( [Total Ticket Count] ) annotation value. 

    IF (
     MAX ( [Days in Date] ,
      IF ( 
       MAX( [Calendar Year]*10000 + [Calendar Month]*100 + [Calendar Day Of Month] ) = 20210722
       , 1
       , NULL
      )
     ) = 1
     , RSUM ( [Total Ticket Count] )
     , NULL
    )

Reply
  • $organization in reply to Jerry Hodgins

    Hi Jerry,

    If you still want to set a specific Date, and then have it annotate a given Week in Date, this is probably the most reliable approach: 

    For each date in the given x-axis week, see if that date is the desired annotation date, and if so, return a 1 to the Week. If the max value in any given week then is 1, render the RSUM( [Total Ticket Count] ) annotation value. 

    IF (
     MAX ( [Days in Date] ,
      IF ( 
       MAX( [Calendar Year]*10000 + [Calendar Month]*100 + [Calendar Day Of Month] ) = 20210722
       , 1
       , NULL
      )
     ) = 1
     , RSUM ( [Total Ticket Count] )
     , NULL
    )

Children