Hello,
I am trying to create dashboards with “rollup” index but no luck due to time field.
I am able to add time field in data source settings, but in dashboard section it showing warning “Could not find a rollup job that can answer this query because [missing field @timestamp.date_histogram]”
I have tried with Grafana versions 8.4.2 & 9.0.6, but same error.
Data Source settings:
Dashboard:
Rollup index mappings:
{
"rollup_heal_collated_kpi_core_group_kpis_group_kpi" : {
"mappings" : {
"_meta" : {
"schema_version" : 1,
"rollups" : {
"rollup_heal_collated_kpi_core_group_kpis_group_kpi" : {
"enabled_time" : 1659529539899,
"target_index" : "rollup_heal_collated_kpi_core_group_kpis_group_kpi",
"description" : "",
"source_index" : "heal_collated_kpi_core_group_kpis_qa-d681ef13-d690-4917-jkhg-6c79b-1_2022.02*",
"enabled" : true,
"rollup_id" : "rollup_heal_collated_kpi_core_group_kpis_group_kpi",
"schema_version" : 12,
"schedule" : {
"interval" : {
"schedule_delay" : 120000,
"start_time" : 1659529539899,
"period" : 1,
"unit" : "Minutes"
}
},
"delay" : 120000,
"last_updated_time" : 1659529539899,
"continuous" : true,
"metadata_id" : "iIatY4IBEul_OggVB5on",
"metrics" : [
{
"source_field" : "value",
"metrics" : [
{
"min" : { }
},
{
"max" : { }
},
{
"sum" : { }
},
{
"avg" : { }
},
{
"value_count" : { }
}
]
}
],
"user" : {
"backend_roles" : [
"admin"
],
"custom_attribute_names" : [ ],
"roles" : [
"own_index",
"all_access"
],
"name" : "admin",
"user_requested_tenant" : null
},
"page_size" : 1000,
"dimensions" : [
{
"date_histogram" : {
"fixed_interval" : "1m",
"source_field" : "@timestamp",
"target_field" : "@timestamp",
"timezone" : "Asia/Calcutta"
}
},
{
"terms" : {
"source_field" : "@timestamp",
"target_field" : "@timestamp"
}
},
{
"histogram" : {
"source_field" : "kpiId",
"target_field" : "kpiId",
"interval" : 1.0
}
},
{
"histogram" : {
"source_field" : "value",
"target_field" : "value",
"interval" : 3.0
}
},
{
"terms" : {
"source_field" : "timeInGMT",
"target_field" : "timeInGMT"
}
},
{
"terms" : {
"source_field" : "compInstanceIdentifier",
"target_field" : "compInstanceIdentifier"
}
}
]
}
}
},
"dynamic_templates" : [
{
"strings" : {
"match_mapping_type" : "string",
"mapping" : {
"type" : "keyword"
}
}
},
{
"date_histograms" : {
"path_match" : "*.date_histogram",
"mapping" : {
"type" : "date"
}
}
}
],
"properties" : {
"@timestamp" : {
"properties" : {
"date_histogram" : {
"type" : "date"
},
"terms" : {
"type" : "long"
}
}
},
"compInstanceIdentifier" : {
"properties" : {
"terms" : {
"type" : "keyword"
}
}
},
"kpiId" : {
"properties" : {
"histogram" : {
"type" : "float"
}
}
},
"rollup" : {
"properties" : {
"_doc_count" : {
"type" : "long"
},
"_id" : {
"type" : "keyword"
},
"_schema_version" : {
"type" : "long"
}
}
},
"timeInGMT" : {
"properties" : {
"terms" : {
"type" : "long"
}
}
},
"value" : {
"properties" : {
"avg" : {
"properties" : {
"sum" : {
"type" : "float"
},
"value_count" : {
"type" : "long"
}
}
},
"histogram" : {
"type" : "float"
},
"max" : {
"type" : "float"
},
"min" : {
"type" : "float"
},
"sum" : {
"type" : "float"
},
"value_count" : {
"type" : "long"
}
}
}
}
}
}
}
It would be a great help if somebody suggest me with the solution.
Thanks in advance