Unable to Vizualize Documents with Dates

Elastic Stack Kibana
1

I am having trouble visualizing indices with dates in Kibana. It appears
I am entering data correctly since I see the data when I do a GET
request. However, I cannot visualize it after I create a data view.
Kibana sees all fields as empty. Here is my request/reply chain from the
Dev Tools Console.

PUT _index_template/rsmallidx
{
  "index_patterns": [
    "rsmallidx*"
  ],
  "template": {
    "mappings" : {
      "properties" : {
        "myEvent" : {
          "properties" : {
            "myfloat" : {
              "type" : "float"
            },
            "mytext" : {
              "type" : "text",
              "fields" : {
                "keyword" : {
                  "type" : "keyword",
                  "ignore_above" : 256
                }
              }
            },
            "sendTime" : {
              "type" : "date",
              "format" : "epoch_millis"
            },
            "uid" : {
              "type" : "text",
              "fields" : {
                "keyword" : {
                  "type" : "keyword",
                  "ignore_above" : 256
                }
              }
            }
          }
        }
      }
    },
    "settings": {
      "number_of_shards": 2,
      "number_of_replicas": 1
    },
    "aliases": {
      "some_rsmallidx": {}
    }    
  }
}

{
"acknowledged" : true
}

PUT rsmallidx1/_doc/1
{
    "myEvent": {
           "myfloat": 9999999.0,
           "mytext": "jasonh", 
           "sendTime": "1658945546000", 
           "uid": "57b68fafd2ce0f28"
   }
}

{
"_index" : "rsmallidx1",
"_id" : "1",
"_version" : 1,
"result" : "created",
"_shards" : {
"total" : 2,
"successful" : 1,
"failed" : 0
},
"_seq_no" : 0,
"_primary_term" : 1
}

GET rsmallidx/_search

**{
"took" : 180,
"timed_out" : false,
"_shards" : {
"total" : 2,
"successful" : 2,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 1,
"relation" : "eq"
},
"max_score" : 1.0,
"hits" : [
{
"_index" : "rsmallidx1",
"_id" : "1",
"_score" : 1.0,
"_source" : {
"myEvent" : {
"myfloat" : 9999999.0,
"mytext" : "jasonh",
"sendTime" : "1658945546000",
"uid" : "57b68fafd2ce0f28"
}
}
}
]
}
}
**

Help with this issue would be greatly appreciated. Thank you.

2

Hello @jhop ! Are you sure your time filter is far back enough to pick up the data? Looks like your epoch timestamp is for Jul 27, 2022 @ 20:12:26.000z.

Kibana defaults to showing the last 15 minutes of data (see the time filter to the top right).

1 Like
3

Thanks for the response @JLeysens . I changed the filter to go back 15 Months still nothing.

4

Sorry I did not hit the update button after I changed the filter. Yes it works. Thank you so much for your help.

5

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.