How to create Visualization from calculated field on Kibana
I have a simple index which contains documents representing user requests in dialogs. Each request has a user_id and session_id.
I want to create a Pie graph like this :
Pie chart example showing how much dialogs for each user grouped by number of dialogs.
I couldn't make this using Kibana create Visualization tool. I have tried to make it with SQL request but it doesn't work.
Here an example of the simple dataset : my dataset, after this, I made a query to show for each user, how much dialogs he has : Number of dialogs for each user, and finally I have tried to group the dialog count to obtain the result needed to create the Pie but it bugs ... Failed result.
If this isn't possible on Kibana, how can data analysts create complex graphs based on calculated fields ?
elasticsearch kibana elastic-stack elasticsearch-aggregation kibana-6
edited Jan 19 at 13:09
Mysterion
6,43421942
asked Jan 18 at 15:48
Wassim Ben AmorWassim Ben Amor
11
add a comment |
I have a simple index which contains documents representing user requests in dialogs. Each request has a user_id and session_id.
I want to create a Pie graph like this :
Pie chart example showing how much dialogs for each user grouped by number of dialogs.
I couldn't make this using Kibana create Visualization tool. I have tried to make it with SQL request but it doesn't work.
Here an example of the simple dataset : my dataset, after this, I made a query to show for each user, how much dialogs he has : Number of dialogs for each user, and finally I have tried to group the dialog count to obtain the result needed to create the Pie but it bugs ... Failed result.
If this isn't possible on Kibana, how can data analysts create complex graphs based on calculated fields ?
elasticsearch kibana elastic-stack elasticsearch-aggregation kibana-6
edited Jan 19 at 13:09
Mysterion
6,43421942
asked Jan 18 at 15:48
Wassim Ben AmorWassim Ben Amor
11
add a comment |
I have a simple index which contains documents representing user requests in dialogs. Each request has a user_id and session_id.
I want to create a Pie graph like this :
Pie chart example showing how much dialogs for each user grouped by number of dialogs.
I couldn't make this using Kibana create Visualization tool. I have tried to make it with SQL request but it doesn't work.
Here an example of the simple dataset : my dataset, after this, I made a query to show for each user, how much dialogs he has : Number of dialogs for each user, and finally I have tried to group the dialog count to obtain the result needed to create the Pie but it bugs ... Failed result.
If this isn't possible on Kibana, how can data analysts create complex graphs based on calculated fields ?
elasticsearch kibana elastic-stack elasticsearch-aggregation kibana-6
edited Jan 19 at 13:09
Mysterion
6,43421942
asked Jan 18 at 15:48
Wassim Ben AmorWassim Ben Amor
11
I have a simple index which contains documents representing user requests in dialogs. Each request has a user_id and session_id.
I want to create a Pie graph like this :
Pie chart example showing how much dialogs for each user grouped by number of dialogs.
I couldn't make this using Kibana create Visualization tool. I have tried to make it with SQL request but it doesn't work.
Here an example of the simple dataset : my dataset, after this, I made a query to show for each user, how much dialogs he has : Number of dialogs for each user, and finally I have tried to group the dialog count to obtain the result needed to create the Pie but it bugs ... Failed result.
If this isn't possible on Kibana, how can data analysts create complex graphs based on calculated fields ?
elasticsearch kibana elastic-stack elasticsearch-aggregation kibana-6
elasticsearch kibana elastic-stack elasticsearch-aggregation kibana-6
edited Jan 19 at 13:09
Mysterion
6,43421942
asked Jan 18 at 15:48
Wassim Ben AmorWassim Ben Amor
11
edited Jan 19 at 13:09
Mysterion
6,43421942
asked Jan 18 at 15:48
Wassim Ben AmorWassim Ben Amor
11
edited Jan 19 at 13:09
Mysterion
6,43421942
edited Jan 19 at 13:09
Mysterion
6,43421942
edited Jan 19 at 13:09
Mysterion
6,43421942
6,43421942
asked Jan 18 at 15:48
Wassim Ben AmorWassim Ben Amor
11
asked Jan 18 at 15:48
Wassim Ben AmorWassim Ben Amor
11
asked Jan 18 at 15:48
Wassim Ben AmorWassim Ben Amor
11
11
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54257291%2fhow-to-create-visualization-from-calculated-field-on-kibana%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54257291%2fhow-to-create-visualization-from-calculated-field-on-kibana%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
