2 Replies Latest reply on Sep 14, 2018 3:16 PM by swaroop.gantela

    Filter Out Former Employees  from a Run Chart

    Brian  Fase

      I have a productivity run chart with average items processed per hour on the Y axis and Months of the Year on the X-axis.  Each employee's average monthly productivity is plotted with a line from the beginning of the fiscal year to the most current month.  We have about 20% turnover in employees so there are many former employees that have productivity data on the chart from the beginning of the year but none in the last few months.  I want to be able to setup a dynamic filter that will check to see if an employee has any productivity data in the current month and if no data is found then that employee would be filtered out leaving only employees that have productivity data in the most current month to have their data displayed for the entire fiscal year to date run chart.  Any help in figuring this out is appreciated.  Thanks.