Not able to create Canvas Bar chart Element

Elastic Stack Kibana
1

Dear All,

Am trying to create Bar chart element in Canvas. After selecting the corresponding Index in Data section and saving it, But in display section am not able to get any attributes in dropdown.
Also tried selecting attributes(Priority and Ticket Number) by writing SQL query, Am able to get the attributes in dropdown, But not able to get priority attribute in Y-Axis.

Request all of you to help me achieve to create the chart in particular manner.(x-axis - Ticket Count and Y-axis - Priority).
Attaching the screenshots for your reference.

Regards,
Vinay N

Scenario%20-1
Scenario -1.jpg2716×1106 87.1 KB

Expected%20result
Expected result.jpg2716×1106 36.3 KB

Scenario%20-2
Scenario -2.jpg2716×1106 82.6 KB

2

Hi @vinay.rao ,

How does your index mapping look like? Can you share it?

Best,
Oleg

3

Continuing the discussion from Not able to create Canvas Bar chart Element:

Dear @azasypkin,

PFA the attachment for your reference.

Index-Mapping
Index-Mapping.jpg573×617 73.9 KB

4

Hmm, but I don't see any number or priority fields that you were talking about here?

It'd be better if you can copy the actual mapping from Management -> Index Management instead (click on index and look into Mapping tab), this way we can be 100% sure about the actual mapping.

Best,
Oleg

5

Dear @azasypkin,

Thanks for detail guidance. PFA below detail for your reference.

{
"mapping": {
"doc": {
"properties": {
"@timestamp": {
"type": "date"
},
"@version": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"http_poller_metadata": {
"properties": {
"code": {
"type": "long"
},
"content-type": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"date": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"expires": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"link": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"pragma": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"server": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"set-cookie": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"strict-transport-security": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"transfer-encoding": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"x-is-logged-in": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"x-total-count": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"x-transaction-id": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
}
}
},
"response_message": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"runtime_seconds": {
"type": "float"
},
"times_retried": {
"type": "long"
}
}
},
"http_request_failure": {
"properties": {
"backtrace": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"error": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"name": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"request": {
"properties": {
"method": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"url": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
}
}
},
"runtime_seconds": {
"type": "float"
}
}
},
"message": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"result": {
"properties": {
"assigned_to": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"number": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
"priority": {
"type": "text",
"fields": {
"keyword": {
"type": "keyword",
"ignore_above": 256
}
}
},
Regards,
Vinay N

6

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