Post reply

Indicators for Text

  • March 18, 2014 at 1:58 pm

    #289436

    I need to show a Green Indicator if Fieldname!Status.Value is "Yes" and Red for No, How can I achieve this?

  • March 18, 2014 at 2:49 pm

    #1698198

    Got one to work... The part that tripped me up is that the gauge is expecting a numeric value for the state, so if you pass a string/text to it, it won't work. I started with this dataset

    SELECT 1 AS QID, 'Yes' AS Answer

    UNION ALL

    SELECT 2 AS Expr1, 'No' AS Expr2

    UNION ALL

    SELECT 3 AS Expr1, 'Yes' AS Expr2

    UNION ALL

    SELECT 4 AS Expr1, 'No' AS Expr2

    UNION ALL

    SELECT 5 AS Expr1, 'Yes' AS Expr2

    and it didn't work (no numeric value to connect to, because Expression2 is text.)

    When I created a calculated value to convert Yes/No to 1/0, then it worked. I attached a super simple example. You could do the calculation for the indicator in your query/stored procedure instead of doing it in the report. I just did it that way to make it self-contained.

    I removed the yellow light in my example, since it was mapping yes/no values to green/red.

    HTH

    Pieter

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply