3

I use Metabase for data visualization.

Druid (imply-2.2.3) is data storage.

Created Metabase Questions I put on the dashboard and filter them all by Date Range.

When I try to add Date Range filter to question created by native query, metabase just can't find timestamp field for filtering and says: 'No valid fields': enter image description here

Same problem even if I convert question, created by UI constructor to native query by using "View native query" option:

enter image description here

Generated Native query to Druid:

{
    "intervals": ["1900-01-01/2100-01-01"],
    "granularity": {
        "type": "period",
        "period": "P1D",
        "timeZone": "UTC"
    },
    "context": {
        "timeout": 60000
    },
    "queryType": "timeseries",
    "dataSource": "DotmailerCampaign",
    "aggregations": [{
        "type": "javascript",
        "name": "sum",
        "fieldNames": ["numOpens"],
        "fnReset": "function() { return 0 ; }",
        "fnAggregate": "function(current, x) { return current + (parseFloat(x) || 0); }",
        "fnCombine": "function(x, y) { return x + y; }"
    }],
    "descending": false
}

What is missed?

Rodrigue
  • 3,617
  • 2
  • 37
  • 49
Bo.
  • 605
  • 1
  • 12
  • 28

0 Answers0