Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

How to only show data that is in the timeframe filter that I have in a cross table


Jake Werber

Recommended Posts

I have a cross table that is showing what date and the hours for the date that they were scheduled to work but had a no call no show for employees, it also show what there schedule is for the next 7 days. The problem I am having is with the table showing people that have not had a NCNS in the time frame of the date filter I am using. For example Joe Smith had a NCNS on 07/01/2020 but I filtered it down to show 10/28/2020 - 11/05/2020 the cross table is still showing his name even though he has not had a NCNS in that time frame. I have filtered it through the data limiting to only show people that have had a NCNS. As you can see in the picture I have attached that the top agent has had NCNS and the bottom filter has not but he is still showing. Do you have any suggestions on how I can exclude him
Link to comment
Share on other sites

×
×
  • Create New...