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?
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |