Drill down to sql-based table

Hi, everyone!

I've just started my acquaintance with Metabase.
For test purposes I created dashboard:

Next I created five Questions, based on SQL-queries to get information by clicking on number.
Next I added behavior for main dash - numbers are clickable and should lead to table with appropriate data.
Next I enabled sharing for dash, copied link and opened in different browser, tried to click and got next result:

But for administrator/developer it works properly.

What am I doing wrong?

Hi @NewBee
Click Behavior needs to use the Custom URL pointing to the other shared object.
You are sharing the dashboard, which does not automatically give access to any other objects.
https://github.com/metabase/metabase/issues/14009 - upvote by clicking :+1: on the first post

1 Like

@flamber thank you!

Is it possible to add behavior to destination table? Some button to return to the main dashboard? For users it is not clear to return to main dash via clicking button "back" in the browser...

@NewBee You can add a Textbox with a link back to the main dashboard, there's a request for it:
https://github.com/metabase/metabase/issues/23375 - upvote by clicking :+1: on the first post

Text box doesn't have behavior settings...

@NewBee You can still create a Textbox with a link to your main dashboard - that has nothing to do with Click Behavior.

So, I managed to use Custom URL in behavior instead of Questions. URL: http://localhost:3000/question/26-param-q-color?color=GREEN&type=Apple
And again I get "Not found"... Not enough rights again?

@NewBee If you are using Public Sharing, then you have to link to another Public Link. You cannot link to an internal object from a Public object, since you don't have the permissions without logging in first.

Ok, I've got it. But don't understand how to send parameters to Shared link?

By steps:

  1. I've created Query like: select a, b , c from table where true and color = {{color}} and fruit = {{fruit}}
  2. Saved it
  3. Opened the section "Your personal collection", opened my query -> Sharing -> Enable sharing -> Copy link.
  4. I have link like http://localhost:3000/public/question/f2592475-0f84-422f-8646-859524b462b7... I've tried to add parameters to it like link+"?color= {{color}}&fruit={{fruit}}" and failed with result.

@NewBee Just go to the question and try to set the filters you see, then look in the URL.
If this doesn't work, then record a screencast showing everything you are doing, since you're doing something wrong somewhere.

And post "Diagnostic Info" from Admin > Troubleshooting.