Unanswered

Filtering issue

(0) Share

Report

Posted on by Russorusso

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?

Categories:

Governance & administering

I have the same question (0)

All responses (7)

Answers (0)

v-xiaochen-msft on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Russorusso 6 on at

Like (0)

Report

I have 600 records, yes I have that set to 2000.

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Russorusso 6 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @Russorusso ,

Could you provide your formula and the data type of the columns mentioned in the formula?

Best Regards,
Wearsky

Was this reply helpful? Yes No
Russorusso 6 on at

Like (0)

Report

I’m using the collect formula and the table records are text.

thank you for helping with this issue

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No