Dashboard view with filtered records

Hello community,
I’m looking for a solution to link with a dashboard view with filtered items, starting from a deck view.
I have 2 tables:

  1. ‘Jobs’ confirmed by operators with building and month columns.
  2. ‘buildings’ with columns ‘name’ and ‘month’.
    User adds buildings in second table (deck view) filling ‘name’ and ‘month’ columns.
    I desire to create an action going to a dashboard views with only filtered jobs table based on ‘name’ and ‘month’ specified in each row of table 2 where action starts.
    I tried with:

LINKTOFILTEREDVIEW(“dashboard”,
AND(
CONTAINS([month], [_THISROW].[month]),
[building] = [_THISROW].[building]

But all rows are returned. I red about some problems about using LINKTOFILTEREDVIEW with dashboard, so how can I solve the problem?
Maybe creating a custom link?
Thanks for your help.

First, just to be clear “dashboard” is an actual Dashboard type view showing two or more other views together?

If so, then your function will not work as written. The view specified in LINKTOFILTEREDVIEW() needs to be one that can apply the filter logic to reduce rows. Dashboards do not have rows, just a set of views.

Can you show an image of your dashboard to make it more clear?

Hello John,
thanks for your help.
Yes, dashboard (img 1) is intended to put together two different but related views, jobs list and calendar.
Deck view (img 2) is a sort of check view for user: adding buildings, each of them has its information.
User can also specify month he’s working on.
Action is supposed to link with dashboard where only filtered jobs are shown, based on the name of building (so in the example, action for ‘6-condominio primula’ should give me only jobs related to this building in dashboard view).
Instead, all records are reported at the moment.
How could I do?
Thanks


img2

I think you may want to check into Interactive Dashboards. In your case, you would add a third view to the dashboard that acts as the control. Select the control record you wish and the other two views will automatically filter based on the chosen record.

The article below discusses Interactive Dashboards and has an animation showing how it could work. Once yo understand them, they are very, very easy to setup.

1 Like

Thanks John,
I knew dashboard functionalities but I didn’t figure out how to set up for my goals.
Now it is solved.
Thanks!

1 Like

How do you unselect a row in order to see all the rows like in the begining view?

I assume yo mena in an interactive dashboard? You should just be able to tap on that same row again to deselect it.