6 Replies Latest reply on Jul 29, 2016 8:10 AM by Graham Nixon

    Dynamic Tooltip based on Discrete Hour

    Graham Nixon

      Good Morning,

       

      I'm trying to make an custom tool tip that replaces the existing ' <HOUR([Date])>' with a string specifying the range being discussed and I can't seem to figure out how to make it work.

       

      What I currently have is:

      The number of events made in the <HOUR([Date])> hour of the specified date was <AGG(Events)>.

       

       

      What I was trying was something along the lines of converting it to a new field and using that in the tooltip.

      ex:

      If

      <Hour([Date])> = 0 THEN 'Between Midnight and 1am' ELSEIF

      .......

      <Hour([Date])> = 23 THEN 'Between 11pm and Midnight'

      End

       

       

      Anyone had any success with a dynamic tooltip like this?