{"action":"created","issue":{"url":"https://api.github.com/repos/elastic/kibana/issues/4506","labels_url":"https://api.github.com/repos/elastic/kibana/issues/4506/labels{/name}","comments_url":"https://api.github.com/repos/elastic/kibana/issues/4506/comments","events_url":"https://api.github.com/repos/elastic/kibana/issues/4506/events","html_url":"https://github.com/elastic/kibana/issues/4506","id":97712513,"number":4506,"title":"Kibana Data Table - Allow a Field's Values to be Column Names","user":{"login":"Mrc0113","id":1815312,"avatar_url":"https://avatars.githubusercontent.com/u/1815312?v=3","gravatar_id":"","url":"https://api.github.com/users/Mrc0113","html_url":"https://github.com/Mrc0113","followers_url":"https://api.github.com/users/Mrc0113/followers","following_url":"https://api.github.com/users/Mrc0113/following{/other_user}","gists_url":"https://api.github.com/users/Mrc0113/gists{/gist_id}","starred_url":"https://api.github.com/users/Mrc0113/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Mrc0113/subscriptions","organizations_url":"https://api.github.com/users/Mrc0113/orgs","repos_url":"https://api.github.com/users/Mrc0113/repos","events_url":"https://api.github.com/users/Mrc0113/events{/privacy}","received_events_url":"https://api.github.com/users/Mrc0113/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-07-28T13:51:12Z","updated_at":"2015-07-28T14:31:42Z","closed_at":"2015-07-28T14:31:42Z","body":"Kibana Data Table - Allow a Field's Values to be Column Names instead of \"splitting\" the table itself when using a Count.   (Maybe this is possible using the JSON Input options on the data table metrics but I haven't been able to figure it out)\r\n\r\nPer the thread here it was suggested that I open an issue: https://discuss.elastic.co/t/json-input-help-w-kibana-data-table/26025/3\r\n\r\nHere is my use case:  I have applications (services in the image below) that are generating logs throughout message processing.  We have a msg_status field in the generated documents that get marked as \"Received\", \"Processed\", \"Error\", etc depending on the status of the message throughout processing.  \r\n\r\nI then have a requirement to generate a report broken out by day that shows how many messages were received, processed or ended in error. \r\n\r\nWe want something like this: \r\n\r\n**Day 1**\r\nApplication | Received | Processed | Errors\r\n------ | -------- | -------- | ------\r\nApp1 | 100 |  90 | 10\r\nApp2 | 100 | 100 | 0\r\nApp3 | 300 | 297 | 3\r\n\r\n...then repeated for each day in a selected time period. \r\n\r\nHowever since I only seem to be able to split each row by the field value of msg_count the closest I can get is the following:\r\n\r\n![image](https://cloud.githubusercontent.com/assets/1815312/8932028/729d67e6-3508-11e5-9ee7-faf1e6ff9f2f.png)\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/elastic/kibana/issues/comments/125628063","html_url":"https://github.com/elastic/kibana/issues/4506#issuecomment-125628063","issue_url":"https://api.github.com/repos/elastic/kibana/issues/4506","id":125628063,"user":{"login":"rashidkpc","id":1250387,"avatar_url":"https://avatars.githubusercontent.com/u/1250387?v=3","gravatar_id":"","url":"https://api.github.com/users/rashidkpc","html_url":"https://github.com/rashidkpc","followers_url":"https://api.github.com/users/rashidkpc/followers","following_url":"https://api.github.com/users/rashidkpc/following{/other_user}","gists_url":"https://api.github.com/users/rashidkpc/gists{/gist_id}","starred_url":"https://api.github.com/users/rashidkpc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rashidkpc/subscriptions","organizations_url":"https://api.github.com/users/rashidkpc/orgs","repos_url":"https://api.github.com/users/rashidkpc/repos","events_url":"https://api.github.com/users/rashidkpc/events{/privacy}","received_events_url":"https://api.github.com/users/rashidkpc/received_events","type":"User","site_admin":false},"created_at":"2015-07-28T14:31:41Z","updated_at":"2015-07-28T14:31:41Z","body":"Duiplicate of https://github.com/elastic/kibana/issues/3620"}}