# Correlation Matrix

**URL:** <https://discuss.elastic.co/t/correlation-matrix/273583>\
**Category:** Kibana\
**Created:** [May 20, 2021, 7:57pm UTC](https://discuss.elastic.co/t/correlation-matrix/273583 "2021-05-20T19:57:25Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dxenakis](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dxenakis/32/89048_2.png) [@dxenakis](https://discuss.elastic.co/u/dxenakis)\
**Post date:** [May 20, 2021, 7:57pm UTC](https://discuss.elastic.co/t/correlation-matrix/273583/1 "2021-05-20T19:57:25Z")

</div>

Hi,

I have weather data into my elasticsearch from different weather forecast sites. In practice i use (scrapy) spiders in order to crawl the data from the sites and store them to elasticsearch.  
The index field structure contains fields like temperature, humidity, etc and one more field called source where i store the site (name) which the element belongs to.  
I was thinking if it is possible to create a correlation matrix (based on source field,so the columns of the correlation matrix would be the different source's field values) comparing each site's temperature differences, with the rest ones.

Any Ideas?

 ![source](https://us1.discourse-cdn.com/elastic/original/3X/d/5/d56e3f0a6e182ba6c4059b9a167a74ac36968946.png)

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [May 20, 2021, 9:36pm UTC](https://discuss.elastic.co/t/correlation-matrix/273583/2 "2021-05-20T21:36:38Z")

</div>

Hello,

As long as your source field is mapped accordingly yes it is possible.  
Please check out lens -

> **[Lens | Kibana Guide \[7.12\] | Elastic](https://www.elastic.co/guide/en/kibana/current/lens.html)**

Cheers  
Bhavya

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 17, 2021, 9:37pm UTC](https://discuss.elastic.co/t/correlation-matrix/273583/3 "2021-06-17T21:37:35Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.