Map Visualization shows different data in dashboard and in question

Bug reports
1

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

image
image1305×660 338 KB

Data from the question:

image
image1359×581 324 KB

Any reason why this happens?

1 Like
2

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

1 Like
3

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

image
image1340×638 28.3 KB

4

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

5

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

image
image1359×645 350 KB

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

image
image1338×639 31.9 KB

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

image
image1333×654 195 KB

6

@hitomebore 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.

7 
{
  "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"
    }
  }
}
8

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

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

9

@hitomebore 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
10

Will look into that, thank you very much.