Click behavior doesn't work if the table is pivoted

Bug reports
1

Hi! We've recently faced the following bug:

When the table is pivoted on some column, click behavior (that connects column value to the filter in the other dashboard) for this column doesn't lead the user anywhere. However, when the table is unpivoted, clicks work just fine. :thinking:

It would be nice to have full functionality for pivots, so I wonder if something can be done about this issue :raised_hands:

2

Hi @yulia-p
Post "Diagnostic Info" from Admin > Troubleshooting.

3

{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.16+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.16",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.16+8",
"os.name": "Linux",
"os.version": "5.4.196-108.356.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"bigquery-cloud-sdk"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "11.13"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.4.1"
}
},
"run-mode": "prod",
"version": {
"date": "2022-08-16",
"tag": "v1.44.1",
"branch": "release-x.44.x",
"hash": "112f5aa"
},
"settings": {
"report-timezone": null
}
}
}

4

@yulia-p I've just tried to create the old pivoted Table visualization and made a Click Behavior to another dashboard including setting a filter there. It works.

image
image917×613 28.2 KB

image
image679×552 23.1 KB

Can you provide steps-to-reproduce using the Sample Database?
Have you considered using the Pivot Table instead of Table with pivoted?

5

Linking from the values of a pivoted table works works for us as well. Can you try the date/text column as a link instead? In our case bugs appear in the links from the text column (also the left-most column) in a pivoted table.

6

@flamber could you check the case above please?

7

@yulia-p I've created an issue for it:
https://github.com/metabase/metabase/issues/25203 - upvote by clicking :+1: on the first post