Dashboard View: How to add parameter to control values on the views

Hi Community,

Sorry if this was before asked but i could not find a proper answer for myself.

I created a small dashboard with basic parameter. When clicking Show Cancel is true, it is showing cancelled records from Purchase Orders etc.

My question, i cannot click on a record from Purchase Orders to navigate to detail view. No action is triggered when i click. However, when i maximize Purchase Orders tab and click, i can navigate to details. Anyone can suggest how to nagivate without maximazing? I can maybe create a deeplink but not sure if it will work. I havent tried yet.

Is it application behavior or kind of small bug?

Thank you in advance.

Solved Solved
0 7 1,417
1 ACCEPTED SOLUTION

Hello @Suvrutt_Gurjar,
I created screenshots.

First i created a new table that helps me control my parameter which works TRUE or FALSE. I havenโ€™t created a UX view for this because system generated UX is enough for me. Just we need to enable quick editing for Show Cancel column of system generated UX

2X_e_ee3da2a8e82a83c7ac1efe85e0ace7e49d76e18c.png


After setting up assistant table, we need to set up main table which in my case Purchase Orders and Customer Orders.
First i created a new slice using Purchases as source and join Purchases and Yes/No table with a small query as below. Basically, if Show Cancel is True then just show me rows that status equals to Cancelled, else everything but not Cancelled.

IF(ANY(Yes No[Show Cancel])=โ€œTrueโ€,[Order Status] =โ€œCancelledโ€,[Order Status] <>โ€œCancelledโ€)

After setting up the slice, i created a new UX called Purchase Orders with data from this slice. I set position Ref because i actually do not need to see this in the menu, i will use this in my dashboard.

After completing all set up process, i created a new dashboard and used my system generated Yes No_Detail view and Purchase Orders view.

I set up interactive mode On at the beginning but then i click the row from Purchase Orders, i cannot navigate to Form view of selected row, it is just selecting row and make light blue colors. See on first picture below. After asking you, i changed set up and set interactive mode Off, hence i could navigate to form view of selected rows without any problem. You can see on second picture.

I hope i could express all process clearly. And it will help others to create views with parameters. The good thing is 1 assistant table is enough for all True False requirements.

Here is mobile view of the functionality.

View solution in original post

7 REPLIES 7

Hi @furkizio,

May be you are looking for something else than my response below because you have mentioned โ€œnavigating to a detailed viewโ€ and my suggestion does not exactly navigate to but shows the selected detail view within the dashboard itself.

However have you tried to set the interactive mode to yes in dashboard view settings. With this setting on, you will be able to โ€œseeโ€ the detail view of the tapped or rather selected record in summary view (table, deck) in the dashboard view itself. Please also ensure that you have included both summary and detail view in the dashboard.

As the dashboard picture below shows, selecting the summary record (highlighted in light blue by the app itself) shows the details of that record towards the right.

Please post back if you are looking for something else.

Edit: Minor edits in my response above to increase response clarity.

Hi @Suvrutt_Gurjar,

Yes it is because of activating interactive mode. When disabled, i can navigate to detailed view.

Thank you very much

I disabled interactive mode for particular dashboard, when i set Show Cancel true it is updating corresponding view and when i click one of row in the view, i can navigate to detail view of the selected row.

When interactive mode is enabled, i cannot navigate to detail view once i click the row on corresponding view.

Hi @furkizio,

Thank you for the updates. I believe you could share how you are selecting table view for the orders when "Show Cancel"is selected or deselected.

Are you creating a slice on the orders table to show only โ€œcancelโ€ orders or all orders?

Also I believe you may further clarify the expectation when you mean โ€œnavigateโ€ to . Do you wish to further go to the "form " from the detail view ?

I believe you may wish to share a few screenshots if possible.

Thank you for your reply @Suvrutt_Gurjar,

I will create a video about all and reply you

Hello @Suvrutt_Gurjar,
I created screenshots.

First i created a new table that helps me control my parameter which works TRUE or FALSE. I havenโ€™t created a UX view for this because system generated UX is enough for me. Just we need to enable quick editing for Show Cancel column of system generated UX

2X_e_ee3da2a8e82a83c7ac1efe85e0ace7e49d76e18c.png


After setting up assistant table, we need to set up main table which in my case Purchase Orders and Customer Orders.
First i created a new slice using Purchases as source and join Purchases and Yes/No table with a small query as below. Basically, if Show Cancel is True then just show me rows that status equals to Cancelled, else everything but not Cancelled.

IF(ANY(Yes No[Show Cancel])=โ€œTrueโ€,[Order Status] =โ€œCancelledโ€,[Order Status] <>โ€œCancelledโ€)

After setting up the slice, i created a new UX called Purchase Orders with data from this slice. I set position Ref because i actually do not need to see this in the menu, i will use this in my dashboard.

After completing all set up process, i created a new dashboard and used my system generated Yes No_Detail view and Purchase Orders view.

I set up interactive mode On at the beginning but then i click the row from Purchase Orders, i cannot navigate to Form view of selected row, it is just selecting row and make light blue colors. See on first picture below. After asking you, i changed set up and set interactive mode Off, hence i could navigate to form view of selected rows without any problem. You can see on second picture.

I hope i could express all process clearly. And it will help others to create views with parameters. The good thing is 1 assistant table is enough for all True False requirements.

Here is mobile view of the functionality.

Hi @furkizio,

Thank you for all the details. Really appreciate. If I understand your requirement, could you also please add the system detail view of the Purchase Orders ( I believe , its name will be something like โ€œPurchase orders_Detailโ€) also in the dashboard views list after โ€˜Yes No_Detail" and โ€œPurchase Ordersโ€ views under setting "View Entriesโ€™?

Edit: Then please set the dashboard interactive mode to on. No you should be able to see the detail view of the selected row.

I am unsure why you have mentioned โ€œForm Viewโ€ in the latest post. In all earlier posts you had mentioned โ€œdetail Viewโ€. I believe you will be able to go to detail view of the selected row in the interactive dashboard bu t not further to form view.

Top Labels in this Space