5 Replies Latest reply on Aug 18, 2015 6:50 AM by Lori Johnson

    Changing Tooltip Colors Based on Conditions

    Meghan Carton

      I'm trying to make a dynamic tooltip that displays four things for our school district:

       

      Total Budget

      Total Enrollment

      Budget Variance

      Enrollment Variance

       

      Each category is a separate variable. For the two variance variables I am trying to make a calculated field so that if the variance is positive the number shows green and if it is negative then red.

       

      I don't want the variance variables to be displayed in the analysis, just in the tooltip.

       

      I'm fairly sure this requires some kind of KPI but don't know what I need to do in order to have the actual variance number display in the tooltip with just the color of the number changed based on whether it's positive or negative