Bar chart click behavior based on x-axes

I have a bar chart, x-axes is showing a timeseries while y-axes showing sum of quantity. I want a click on each bar will update a date filter on dashboard.

Is there any way to do so?

Many Thanks

Hi @eric.halim
Yes, not sure why it's not working for you, so let's get some information:

  1. Post "Diagnostic Info" from Admin > Troubleshooting.
  2. Post the metadata of the question /api/card/123, where 123 is the question ID
  3. Post the metadata of the dashboard /api/dashboard/321, where 321 is the dashboard ID.

Hi @flamber

Where could I get the metadata of card and dashboard?

@eric.halim Go the to the URL. So if your Metabase is on https://metabase.example.com, then it would be https://metabase.example.com/api/card/123 etc

Ah I got it, but I find metadata can be quite private. Do you mean if I send it in private?
I got error message that you are not accepting any message at this moment. What about email?

@eric.halim
So you can post "Diagnostic Info" from Admin > Troubleshooting to begin with. If you're not using the latest release, then test with that first: https://github.com/metabase/metabase/releases/latest

And then you can use Sample Dataset to try to provide an example of what you're trying to do, but isn't working.

Good suggestion.

By the way, it's my bad. I manage to work it out. I put custom date format on the x-axes so it is not detecting properly.

Anyhow, on click behaviour, it can only update a text filter but not a date filter. But is ok I can still live with it.

@eric.halim If you are returning a string, then Metabase cannot detect it as a date, which is why you cannot parse to different filter types.