Table Security Condition not restricting access as configured

[Daisy_Ramirez]

I have a simple histogram based directly on the table in place and its only displaying 2 out of over 20 records.

I checked the table for security conditions and it does have the following:

IF(“Sales”=LOOKUP(USEREMAIL(),“Users”,“Email”,“Role”),
[Assigned to]=USEREMAIL(),
NOT(ISBLANK([quote_id])))

-I am currently an “Administrator” in the “Users” table.
-I cleared my cache and the system still did not recognize me as an Administrator and restricted the info.
-I removed the security condition on the table to see if the chart would display all records, saved, refreshed but it still only shows the 2 out of 20 overall records.
-Confirmed there is more data than the 2
-Confirmed I’m logged in with the email in the database.
-I double checked its the correct database.
-Tried the following on the security condition as well:

IF(LOOKUP(USEREMAIL(),“Users”,“Email”,“Role”)=“Sales”,
[Assigned to]=USEREMAIL(),
NOT(ISBLANK([quote_id])))

The security condition truly needs to be in place but I’m not sure why its not operating correctly. Have I missed something?

[Steve]

Sounds like the security filter isn’t the problem at all, given:

Daisy_Ramirez:

I removed the security condition on the table to see if the chart would display all records, saved, refreshed but it still only shows the 2 out of 20 overall records.

I suspect your chart view is misconfigured.

[Daisy_Ramirez]

Hi Steve, this is the configuration of the chart: It seemed pretty straight forward but maybe I’ve selected the wrong chart type? I’m looking to get total price for each “Depot” designated on the quote.

[Daisy_Ramirez]

RESOLVED. Regenerated table and now able to see data as expected.