Map Visualization shows different data in dashboard and in question

So I have a map visualization dashboard with 2 filter (sales name and supervisor). But somehow the dashboard and the question shows different data even though the filter is exactly the same. You can clearly see below that there are way more pins (3 different area) in the dashboard, but when I click the question, it actually shows less pins. If I check the raw data, the location should not have been that diverse so the question shows the real data while the dashboard somehow does not

Data from dashboard

Data from the question:

Any reason why this happens?

1 Like

Are you sure that the filters on your dashboard are correctly linked on the card report ?

1 Like

Yup, already make sure to link both filters to the card report, it was the first thing I checked when I see the results are weird

@gurarako It looks like it's different tables
raw_***_store_map_view
*******_store_map_views

That's really weird, I only have 1 table of that name, it's raw_unipro_store_map_views (views with 's')

But when I try to connect the filter to the card in dashboard it shows raw_unipro_store_map_view (view without 's')

And I actually click the question from the dashboard, yet it still shows different results.

Here's a better comparison, the left side is where I filter the question directly and the right side is when I try to use dashboard filter

@gurarako The extra "s" is likely just normalized naming, which adds that, so let's ignore that.
Post "Diagnostic Info" from Admin > Troubleshooting.
And check the request query by looking in your browser developer Network-tab.

{
  "browser-info": {
    "language": "en-US",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36 Edg/91.0.864.64",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.11+9",
    "java.vendor": "AdoptOpenJDK",
    "java.vendor.url": "https://adoptopenjdk.net/",
    "java.version": "11.0.11",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.11+9",
    "os.name": "Linux",
    "os.version": "5.4.0-1048-aws",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "postgres",
      "bigquery"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "12.5"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.18"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2021-04-27",
      "tag": "v0.39.1",
      "branch": "release-x.39.x",
      "hash": "6beba48"
    },
    "settings": {
      "report-timezone": "Asia/Jakarta"
    }
  }
}

And check the request query by looking in your browser developer Network-tab.

What should I look for in the developer Network-tab?

@gurarako You should look in the Response-data of the request, when doing it through the dashboard and through the question - and compare what the difference is.
I would recommend 0.39.4 - or the latest 0.40.0 just released:
https://github.com/metabase/metabase/releases

1 Like

Will look into that, thank you very much.