You’re offline. This is a read only version of the page.
6
Hi.
I have a canvas app displaying a table data of defects. I have two basic sort filters setup pulling in all data. One is to sort by year 2019/ 2020 and the other is to sort by state. When I set my first filter to all years, it works correctly, I see all my data. But when I set it to filter just by state, Some states are not showing the 2020 defects but other states display correctly. So, the filter is working correctly for most all, but some not.
Is there a known PA filtering issue or a performance issue that might be causing this?
Hi @Russorusso ,
I’m afraid it’s difficult for me to help you through the information you gave.
Please provide specific formula and data type.
Best Regards,
Wearsky
I’m using the collect formula and the table records are text.
thank you for helping with this issue
Hi @Russorusso ,
Could you provide your formula and the data type of the columns mentioned in the formula?
Best Regards,
Wearsky
Sorry I already had that set the 2000. No it does not work. What other information Do you think would be helpful for me to share?
Hi @Russorusso ,
So does it work?
If it doesn't work, could you provide more information?
Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
I have 600 records, yes I have that set to 2000.
Hi @Russorusso ,
This looks like a delegation issue.
When using non-delegation functions, only the firstN pieces of data can be processed.
Hope this link will help you: Here
Could you tell me:
How many records do you have in the data source?
If this is a delegation issue and your number of records is greater than 500 and less than 2000,I suggest you modify the setting and change its value to 2000.
If your number of records exceeds 2000, please provide the formula.
Maybe you could use delegation functions instead of non-delegation functions.
Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
#1
Michael E. Gernaey
9
Super User 2025 Season 1
#2
bscarlavai33
5
Super User 2025 Season 1
#3
getsplash
2
Share
Report
All responses (
Answers (
