1 Reply Latest reply on Jul 13, 2016 9:10 AM by Simon Runc

    Need a KPI for Null as nothing

    Anu Rekha
    Anu Rekha Jul 13, 2016 8:45 AM

      Hi All

       

      Hope everyone is fine.

       

      I need to create KPI for a field with positive and negative values.

       

      I am able to put Up and down arrow for those.

       

      But for some records with Null values, I want to suppress KPI Symbol, i.e. I want to show nothing(no arrows, no shapes)

       

      Please help if you have come across similar situations. Thanks in advance.

       

      Regards

      Anu

        • 1. Re: Need a KPI for Null as nothing
          Simon Runc
          Simon Runc Ambassador Jul 13, 2016 9:10 AM (in response to Anu Rekha)

          hi Anu,

           

          There are a few ways (as always with Tableau) you could try.

           

          1. Use custom shapes, and use a blank image, and set the NULL to that image. Let me know if you've not come across custom shapes and I can direct you to some resources

           

          2. Throw the Up/Down/Null dimension onto the colour shelf too...and set the NULL colour to the background colour (eg. white)

           

          Hopefully one of them will do the trick, but if not please post back (with why they aren't working) and I'll have another think!