Visibility Condition Not Working with Filtered Average

Get Help
1

I have a visibility condition that should show a block only if the average of a filtered list is less than a fixed number.

The list is filtered correctly (e.g. Archived = false), and the average calculation is correct — but the visibility condition still returns true, even when the average is clearly higher than the number.

I’ve checked all:

  • The list is filtered
  • The comparison is between two numbers
2

Hi @nadavma2,

In my experience, counts, sums & averages are not very stable in Adalo, especially in conjunction with filters and visibility.
Some things you may try which may help:

  • add a text label to show the average you’re using (with the same filter of course). This helps sometimes. My hypothesis is that visibility may work earlier than average is calculated, and adding a text label makes this calculation to execute earlier.
  • add a property to logged-in user, update this property upon on-screen-enter, put average there, and use this property for conditional visibility.
  • do the same but on the previous screen.

Best,
Victor.

1 Like
3

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.