Dynamic Dashboard Filter Malfunction

[Noemer_Orsolino]

Last month, my dynamic dashboard filter stopped working. The filtered table showed no results when the filter itself is blank. It’s only when you have filled all criteria that a result would show up, but that has not been the effect of the formula until now. I also tried variations of the formula but they did not work either. Was there an update that affected this? Below are some of the resources I used to create the formula and the formula itself.

Dashboard - filter based on user input, multiple filters Questions

Use like this: AND( if(isnotblank(FiltersForCurrentUser[Team Name]), in([Team Name], FiltersForCurrentUser[Team Name]), True), if(isnotblank(FiltersForCurrentUser[Region]), in([Region], FiltersForCurrentUser[Region]), True), if(isnotblank(FiltersForCurrentUser[Status]), in([Status], FiltersForCurrentUser[Status]), True), if(isnotblank(FiltersForCurrentUser[Priority]), in([Priority], FiltersForCurrentUser[Priority]), True), if(isnotblank(FiltersForCurrentUser[Obligation Categories]), in([Obligat…

Multie Select on Filtered Dashboard Questions

Use a column type of EnumList with a base type of Ref. Could also be expressed: AND( OR( ISBLANK(Filters[Filter Client]), IN([Client Name], Filters[Filter Client]) ), OR( ISBLANK(Filters[Filter Site]), IN([Site], Filters[Filter Site]) ), OR( ISBLANK(Filters[Filter Status]), IN([Status], Filters[Filter Status]) ), OR( ISBLANK(Filters[Filter Created Start Date]), (MIN(Filters[Filter Created Start Date]) <= [Date Created]) ), OR( ISBLANK(Fil…

And(
or(isblank(Filter Table[Insurance Filter]),in([Insurance],Filter Table[Insurance Filter])),
or(isblank(Filter Table[Line Item Filter]),in([Line Item],Filter Table[Line Item Filter])),
or(isblank(Filter Table[Project Type]),in([Project Type],Filter Table[Project Type])),
or(isblank(Filter Table[Installer]),in([Caregiver/Installer],Filter Table[Installer])),
or(isblank(Filter Table[Status]),in([Status],Filter Table[Status])),
or(isblank(Filter Table[Region]),in([Region], Filter Table[Region])),
or(isblank(Filter Table[City]),in([City],Filter Table[City]))
)

[Marc_Dillon]

Noemer_Orsolino:

It’s only when you have filled all criteria that a result would show up

This makes me think it is something weird with the ISNOTBLANK() portions of your expression.

Noemer_Orsolino:

And(
or(isblank(Filter Table[Insurance Filter]),in([Insurance],Filter Table[Insurance Filter])),
or(isblank(Filter Table[Line Item Filter]),in([Line Item],Filter Table[Line Item Filter])),
or(isblank(Filter Table[Project Type]),in([Project Type],Filter Table[Project Type])),
or(isblank(Filter Table[Installer]),in([Caregiver/Installer],Filter Table[Installer])),
or(isblank(Filter Table[Status]),in([Status],Filter Table[Status])),
or(isblank(Filter Table[Region]),in([Region], Filter Table[Region])),
or(isblank(Filter Table[City]),in([City],Filter Table[City]))
)

Maybe try to change them to:

ISNOTBLANK( ANY( Filter Table[column] ) )

Notice the addition of ANY().

[Noemer_Orsolino]

Nope no effect either

[Marc_Dillon]

Hmm, ok. Maybe try to convert your

IN( [x] , Table[col] )

…portions to:

[x] = ANY( table[col] )

??

I’ve built this same feature in many apps, and just checked two of them and they still work fine. I always write the expressions as I’ve just asked you to try, though yours shouldn’t definitely work as well.

[Noemer_Orsolino]

Nope. Not working either. What’s weird is that it works when you use the test feature, but it doesn’t when you ‘View Data’ on the filtered slice.

[Marc_Dillon]

Noemer_Orsolino:

What’s weird is that it works when you use the test feature, but it doesn’t when you ‘View Data’ on the filtered slice.

Please provide screenshots of this.

[Noemer_Orsolino]

[Steve]

Possible that the Filter Table has more than one row? isblank(Filter Table[...]) only works for your purpose if the table has only one or no rows.

[Noemer_Orsolino]

The table in ‘View Data’ is no longer blank but the dashboard remains as such. Does the problem lie closer in the structure of the Filter Table?

[Steve]

Noemer_Orsolino:

Does the problem lie closer in the structure of the Filter Table?

Can’t say yet.

The views included in the dashboard actually use slices that use the filter table? You’ve confirmed?

[Noemer_Orsolino]

Steve:

Can’t say yet.

The views included in the dashboard actually use slices that use the filter table? You’ve confirmed?

Yep. The dashboard has the slice versions of the filter table and the filtered main

[Steve]

Please post the configuration for this table:

[Noemer_Orsolino]

Are these what you mean?

[Steve]

What did you do to get the screenshot I used above, that shows no rows? If View Data from a slice, please post a screenshot of the configuration of the slice.

[Noemer_Orsolino]

Yep. View Data from the slice and that was before you suggested to eliminate the empty rows.

[Noemer_Orsolino]

[Steve]

Now I’m confused. You did delete some blank rows from Filter Table? And after doing so, View Data on the slice now shows the correctly filtered rows? But the dashboard does not show the correctly-filtered rows?

[Noemer_Orsolino]

Steve:

Now I’m confused. You did delete some blank rows from Filter Table ? And after doing so, View Data on the slice now shows the correctly filtered rows? But the dashboard does not show the correctly-filtered rows?

Yes

[Steve]

Please post a screenshot demonstrating an affected dashboard view is correctly configured to use the now-working slice.

[Noemer_Orsolino]

[Noemer_Orsolino]

Steve:

Please post a screenshot demonstrating an affected dashboard view is correctly configured to use the now-working slice.

It’s just empty while the filters are blank

[Steve]

I need to see the configurations.

[Noemer_Orsolino]

Steve:

I need to see the configurations.

Dynamic Dashboard Filter Malfunction Questions

[Capture] [Capture1] [Capture2] [Capture3] [Capture4] Are these what you mean?

[Steve]

No.

[Noemer_Orsolino]

These?

[Steve]

Yes, thank you!

The configuration does in fact appear correct, so again I’m think the problem is with the slice. Try using the following as your slice row filter expression instead of what you have currently:

[_ThisRow] = minrow("Filter Table", "_RowNumber", (useremail() = [Email]))

[Noemer_Orsolino]

Steve:

Yes, thank you!

The configuration does in fact appear correct, so again I’m think the problem is with the slice. Try using the following as your slice row filter expression instead of what you have currently:

Still nothing

[Steve]

I’m afraid I’m at a loss, then. I’m going to have to recommend you engage Support so that someone there can look at your app configuration.

https://www.appsheet.com/Support/Contact

[Noemer_Orsolino]

Steve:

[_ThisRow] = minrow("Filter Table", "_RowNumber", (useremail() = [Email]))

Maybe the filter is interpreting it as looking for blank columns? Caregiver/Installer is a ref type column that bases its info on the Id of field employees and some rows in estimate have a blank caregiver/installer column. I got the notion when I isolated the filter formula down to a single criterion:

or(isblank(Filter Table[Installer]),in([Caregiver/Installer],Filter Table[Installer]))

and this is what happens:

and this is what the result are when someone is selected