3 Replies Latest reply: Aug 1, 2013 2:42 AM by Thorsten Schröder RSS

    create quality check using a traffic light gauge

    Thorsten Schröder

      Hello community,

       

      I want to create a quality check using a traffic light gauge but I don't know how to write the syntax.

       

      Each Department has to submit a report each week - so I want to display green for all departments that have submitted reports for all availabe weeks and red if one week is missing.

       

      Fields:

      CalendarWeek

      Department

       

      The Output should be a straight table which lists all Departments with a red or green traffic light next to it, depending on the result.

       

      How do I have to construct the expression? Do I need a set analysis for it?

       

      Thank you.