Hello,
My Elastic version is 6.4.2
I have products with characteristics on which I run some tests.
On each product, I have the following structure:
- Date: Date
- Characteristic1 = XXX
- Characteristic2 = YYY
... - Characteristic20 = ZZZ
- Test1 = 111
- Test2 = 222
... - Test1000 = 333
I'm able to index this data easily in Elasticsearch (1 product is 1 document). Then on Kibana Discover, I can filter on the characteristic XXX or see all products with results of Test1 > 100 for example.
But now I want to create graph with this data. For example, I want a line chart (in Kibana Visualize) with 3 lines (numerical values of test1, test2 and test3) on the last year for products with Characteristic XXX and YYY. I'm not able to do this because it is not possible to plot several fields on the same line chart. How can I do this ?
Another issue with this way is that I have too many fields (> 1000).
An alternative way to index this data will be to create 1000 documents for 1 product
Document1
- Date: Date
- Characteristic1 = XXX
- Characteristic2 = YYY
... - Characteristic20 = ZZZ
- TestName = Test1
- TestValue = 111
Document2 - Date: Date
- Characteristic1 = XXX
- Characteristic2 = YYY
... - Characteristic20 = ZZZ
- TestName = Test2
- TestValue = 222
And so on ...
I am able to do all the charts that I want with this way of indexation. But I don't like this way of indexation because my metadata on each product (characteristics) is replicated too many times. How can I avoid this ?
What are you suggestions ?
Thanks in advance for the help.