{"action":"created","issue":{"url":"https://api.github.com/repos/elastic/kibana/issues/3719","labels_url":"https://api.github.com/repos/elastic/kibana/issues/3719/labels{/name}","comments_url":"https://api.github.com/repos/elastic/kibana/issues/3719/comments","events_url":"https://api.github.com/repos/elastic/kibana/issues/3719/events","html_url":"https://github.com/elastic/kibana/issues/3719","id":72267502,"number":3719,"title":"Define X axis by series of terms","user":{"login":"MaarekElets","id":6320290,"avatar_url":"https://avatars.githubusercontent.com/u/6320290?v=3","gravatar_id":"","url":"https://api.github.com/users/MaarekElets","html_url":"https://github.com/MaarekElets","followers_url":"https://api.github.com/users/MaarekElets/followers","following_url":"https://api.github.com/users/MaarekElets/following{/other_user}","gists_url":"https://api.github.com/users/MaarekElets/gists{/gist_id}","starred_url":"https://api.github.com/users/MaarekElets/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MaarekElets/subscriptions","organizations_url":"https://api.github.com/users/MaarekElets/orgs","repos_url":"https://api.github.com/users/MaarekElets/repos","events_url":"https://api.github.com/users/MaarekElets/events{/privacy}","received_events_url":"https://api.github.com/users/MaarekElets/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/elastic/kibana/labels/needs%20details","name":"needs details","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-04-30T20:03:29Z","updated_at":"2015-04-30T21:16:46Z","closed_at":null,"body":"I'd like to have a way to define the X axis in a visualization as a series of terms. This is hard to describe so I'll give my particular example (and will be very grateful if it turns out I'm just not seeing the right way to do this).\r\n\r\nI have a dataset that contains information about specific items that I'm using Kibana to aggregate and visualize. In each row/document of this dataset there is a series of 10 terms/measurements that represent a value at a certain % (named c10, c20, c30...c100). Basically these are chart points from an individual curve. I'd like to be able to average these points and then chart that aggregate curve.\r\n\r\nI've not yet spotted (or thought of) a good way of doing this short of splitting each item into 10 additional documents with each having a cX and xY value and add a new type to filter them on. Is this a feature/ability that could be added in the future?\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/elastic/kibana/issues/comments/97970466","html_url":"https://github.com/elastic/kibana/issues/3719#issuecomment-97970466","issue_url":"https://api.github.com/repos/elastic/kibana/issues/3719","id":97970466,"user":{"login":"MaarekElets","id":6320290,"avatar_url":"https://avatars.githubusercontent.com/u/6320290?v=3","gravatar_id":"","url":"https://api.github.com/users/MaarekElets","html_url":"https://github.com/MaarekElets","followers_url":"https://api.github.com/users/MaarekElets/followers","following_url":"https://api.github.com/users/MaarekElets/following{/other_user}","gists_url":"https://api.github.com/users/MaarekElets/gists{/gist_id}","starred_url":"https://api.github.com/users/MaarekElets/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MaarekElets/subscriptions","organizations_url":"https://api.github.com/users/MaarekElets/orgs","repos_url":"https://api.github.com/users/MaarekElets/repos","events_url":"https://api.github.com/users/MaarekElets/events{/privacy}","received_events_url":"https://api.github.com/users/MaarekElets/received_events","type":"User","site_admin":false},"created_at":"2015-04-30T21:16:46Z","updated_at":"2015-04-30T21:16:46Z","body":"Here is a manual area graph that I made based on a small sample of the data using another tool. Hopefully it gives a better idea of what I am looking for. In RDBMS terms this would be like pivoting on the field names and having them become your X axes. \r\n\r\n![undefined](https://cloud.githubusercontent.com/assets/6320290/7422581/9f68031c-ef53-11e4-8c31-f268746e9c4d.png)\r\n\r\nIn looking at the nested data discussion I do think that it would give me an avenue if the CvXX values were stored under a parent but I'm not even clear then exactly how it would be done (all depends on the way the feature would be implemented)."}}