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?
Sounds like the security filter isnโt the problem at all, given:
I suspect your chart view is misconfigured.
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.
RESOLVED. Regenerated table and now able to see data as expected.
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |