2 Replies Latest reply on Nov 5, 2018 12:57 AM by Yan Ting Tan

    Visualization - Highlighting null records in table

    Yan Ting Tan

      I have this set of data with Invoice PO Doc Number, PO Doc Number and SC Doc Number.

       

      I am trying to visualize the records with missing documents. For example, for a particular PO Doc Number, if Invoice PO Doc Number or SC Doc Number is missing, I would like to flag it out by highlighting it.

       

      How do I go about to create this visualization?

       

      Sample :

       

      PO Doc Number        Invoice PO Doc Number        SC Doc Number

      10100445                                   null                               null

      10100446                                   null                              500001393

      10100447                              10100447                          null

      10100448                              10100448                          500001398

      10100449                              10100449                           null

       

      Thank you!