# Kibana4.1.1 Matrix report **URL:** \ **Category:** Kibana\ **Created:** [September 2, 2015, 6:59pm UTC](https://discuss.elastic.co/t/kibana4-1-1-matrix-report/28549 "2015-09-02T18:59:28Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![sureshadapa](https://avatars.discourse-cdn.com/v4/letter/s/0ea827/32.png) [@sureshadapa](https://discuss.elastic.co/u/sureshadapa)\ **Post date:** [September 2, 2015, 6:59pm UTC](https://discuss.elastic.co/t/kibana4-1-1-matrix-report/28549/1 "2015-09-02T18:59:29Z")
Hello, I am having below data in DB insert into FOCUSTRPF(id,FOCUSTIER) VALUES(1,'4-Low'); insert into FOCUSTRPF(id,FOCUSTIER) VALUES(2,'4-Low'); insert into FOCUSTRPF(id,FOCUSTIER) VALUES(3,'5-Very Low'); insert into FOCUSTRPF(id,FOCUSTIER) VALUES(4,'1-Urgent'); insert into FOCUSTRPF(id,FOCUSTIER) VALUES(5,'2-High'); insert into FOCUSTRPF(id,FOCUSTIER) VALUES(6,'3-Medium'); This data is getting loaded into ES using logstash-input-jdbc plugin. Now in Kibana4.1.1 - Discover page i see correct data with 2 columns. but when I go to Visualize page, I notice that column-2 data mentioned above is split into multiple tokens. How to avoid that. Is it a bug? ---
**Author:** ![sureshadapa](https://avatars.discourse-cdn.com/v4/letter/s/0ea827/32.png) [@sureshadapa](https://discuss.elastic.co/u/sureshadapa)\ **Post date:** [September 2, 2015, 7:49pm UTC](https://discuss.elastic.co/t/kibana4-1-1-matrix-report/28549/2 "2015-09-02T19:49:31Z")
How to add Exact-Value to that column-2 ---
**Author:** ![sureshadapa](https://avatars.discourse-cdn.com/v4/letter/s/0ea827/32.png) [@sureshadapa](https://discuss.elastic.co/u/sureshadapa)\ **Post date:** [September 2, 2015, 8:17pm UTC](https://discuss.elastic.co/t/kibana4-1-1-matrix-report/28549/3 "2015-09-02T20:17:48Z")
{ "terms" : { "focustier" : ["1-Urgent","2-High","3-Medium","4-Low","5-Very Low"] } } Trying Json input above,but no luck. ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [September 3, 2015, 2:13am UTC](https://discuss.elastic.co/t/kibana4-1-1-matrix-report/28549/4 "2015-09-03T02:13:38Z")
No, it's not a bug, that's the analysis part of indexing that ES does. Trying looking for a `.raw` field with the same name as the other one. ---
**Author:** ![sureshadapa](https://avatars.discourse-cdn.com/v4/letter/s/0ea827/32.png) [@sureshadapa](https://discuss.elastic.co/u/sureshadapa)\ **Post date:** [September 3, 2015, 10:07am UTC](https://discuss.elastic.co/t/kibana4-1-1-matrix-report/28549/5 "2015-09-03T10:07:06Z")
# Login into Kibana and remove focustrpf from "settings tab" Login to Elastic Search marvel plugin [http://localhost:9200/\_plugin/marvel/sense/index.html](http://localhost:9200/_plugin/marvel/sense/index.html) execute below commands DELETE focustrpf PUT focustrpf GET focustrpf GET focustrpf/focustrpf/\_mapping the o/p for above is {} PUT focustrpf/focustrpf/\_mapping { "focustrpf" : { "properties" : { "focustier" : { "type": "string", "fields": { "raw": { "type": "string", "index": "not\_analyzed" } } }, "id" : { "type" : "long" }, "@version" : { "type": "string" } } } } # Check if the mapping is updated GET focustrpf/focustrpf/\_mapping # Load data using logstash. E:\Apps\elasticsearch\logstash-1.5.3\bin\>logstash.bat -f ../config/jdbc2c-config.txt io/console not supported; tty will not be manipulated '[DEPRECATED] use `require 'concurrent'` instead of `require 'concurrent_ruby'` Logstash startup completed Logstash shutdown completed Login to Kibana and add focustrpf Indexed data. I can view the focustier.raw in Discover Page,But it has no value. The value i notice is "-" Please advice.. ---
**Author:** ![sureshadapa](https://avatars.discourse-cdn.com/v4/letter/s/0ea827/32.png) [@sureshadapa](https://discuss.elastic.co/u/sureshadapa)\ **Post date:** [September 3, 2015, 10:08am UTC](https://discuss.elastic.co/t/kibana4-1-1-matrix-report/28549/6 "2015-09-03T10:08:51Z")
And nothing comes up for this "focustier.raw" field in the Visual Page as well. ![](https://us1.discourse-cdn.com/elastic/original/2X/5/55c94991917bf1ff5e7ef5a8683b5af1f6ad9703.png) ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [September 4, 2015, 2:01am UTC](https://discuss.elastic.co/t/kibana4-1-1-matrix-report/28549/7 "2015-09-04T02:01:32Z")
KB doesn't display the `.raw` fields there, try building a visualisation with it instead. ---
**Author:** ![sureshadapa](https://avatars.discourse-cdn.com/v4/letter/s/0ea827/32.png) [@sureshadapa](https://discuss.elastic.co/u/sureshadapa)\ **Post date:** [September 28, 2015, 5:31pm UTC](https://discuss.elastic.co/t/kibana4-1-1-matrix-report/28549/8 "2015-09-28T17:31:56Z")
![](https://us1.discourse-cdn.com/elastic/original/2X/0/0d9c23d37c5269df7f79c82094398dd9c59f40be.png) No luck in visualisation ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [September 29, 2015, 5:01am UTC](https://discuss.elastic.co/t/kibana4-1-1-matrix-report/28549/9 "2015-09-29T05:01:04Z")
Are you looking at the right time range? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 2:12pm UTC](https://discuss.elastic.co/t/kibana4-1-1-matrix-report/28549/10 "2017-07-06T14:12:16Z")