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, then it would be 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?

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:

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.