# Radar Chart with Dynamic Data

**URL:** <https://discuss.elastic.co/t/radar-chart-with-dynamic-data/285002>\
**Category:** Kibana\
**Tags:** vega\
**Created:** [September 23, 2021, 12:18pm UTC](https://discuss.elastic.co/t/radar-chart-with-dynamic-data/285002 "2021-09-23T12:18:54Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![bodach](https://avatars.discourse-cdn.com/v4/letter/b/a87d85/32.png) [@bodach](https://discuss.elastic.co/u/bodach)\
**Post date:** [September 23, 2021, 12:18pm UTC](https://discuss.elastic.co/t/radar-chart-with-dynamic-data/285002/1 "2021-09-23T12:18:54Z")

</div>

Hello,

I am a beginner with Kibana and Vega. I m trying to create a radar chart with an index.  
I managed to create a chart with static values. See below:

[vega code](https://vega.github.io/editor/#/url/vega/N4IgJAzgxgFgpgWwIYgFwhgF0wBwqgegIDc4BzJAOjIEtMYBXAI0poHsDp5kTykSArJQBWENgDsQAGhAB3GgBN6aACwAGNTPg0yWVRpk4kChTXFl9MpA0xsINAF5w0oTAE8cz9OInOZUCUwkMwg0ECMTMwsAXxl7MnEkABtQ1ABtUESELxAAJ2MaBlCZBhwFJEwc+SUYAAICWoAmEGiAXRlyoLQMkCycoKYkvxBiZIY4VJ6AhnFMXLcwgFEyD0xpEAAlCqi0AE4ZIIBrOHEAfQkwxrVGgEYAWjUANgfd2pu1VA1UAQB2dYViKcIAxcqQFugAOInOD5JK1ACCOBwSRoUG2ElqAA1PLkaCcoHBagBlEFg-5wIy5TDZWanUwQZFINyjJLjMIAYTYADMuXBnLFQNNZvMwgApJBGSQyLaYHaoAAcByQxzOF3QV1uD2eale70+H1+-0BwNBcHBICh4hhyQRSJRaNlGOxMLx4gJxNJZvJlOpJ0wdJoDKSTJZbPQABEdHRki0pIK2DM5uaIbk+QT1jK5SolSrzpJ1dd7k8Xm8Pl9DR1jZ7zQAhIpmCYQW3I1Ho8RYnGu90k00LDoUpBUmn++mM5ljHIAWTgpigDdj8cTIvQADF8m7hpnzGhFSAjic85dC1qS3ry39K0Dq2E6-YrRAm4iWw72O3nbj8YSe2T+z7hwGgxDCcwgACQ2BcQCFJMxQlJApU2bZt1QH4cwPNUQA1IttV1MsDQvEAASvXsb3re9HztVtHTfTtPw9Yjf0HX1aVHYNx1ZHJI1oIIkggqDlxAcVJQzRCLFQd5UNVfMMOPYsdVLfVvnwwiTTJdBbwbB9m3tNsOxdWjvy9Bihz9ACx1DHIAAUoF4hNhXNQS4OE2UkN3fdJKPTVZJwhSKwIqtiLU0jGy0yjX10j8Nzon8CIHYzmMDMzgPQKybKXezYPgrdRNc5U0KkzCTzks88KNIjVJAdSyJCl8nRoyKDL7GK-xMligPYsJp1necBUg2zoIjE5kFyQ4nLlABmCTDwLTzsPk89SpUr1ArvYKn20qjwq7L9ryMpiRwS1jzLCFKer480ADk4HoGFg3EBRigQ5zRMeSb0IKry5pKy9FuTaFYWqnT3y2qLDKaxj-1atiwxAMDUrssIABUQUOGg3E3ES0AEV78pk2bisUhbr2WjTyOfQG6u7Hawbi-bAKhnJOR5PkWnaPd1wgLk2FyBBulcDwciQMgyFTChKnWYWExwJhwTSam9tMw7gNZrk8SSe7ukenZWbYPANaQUh8jIZxWaQSZNe3Vo2h6vowmONwHrEEF03QAYhnWOY4I5rmefSPnPDCQXhb4MWZAl0ppY1hRYvlyGjst+O4jRIZJkyJBsgD8wGGDXJ3f5sIcDYMw1hkdcjZcEB4kSHj0DSO4LIASSkWoG9aWNwmMUwkLUSgsYIthkDMcvOhQF2kEGYYVbgNWwij5r4rpo7omttOcnyUwYwOPP0BRK1B3WUuvFASuYxrzRajXwoIFb2IQCcXI2DQOZxhkcRUS8LlkggOAOn74J81AYeYRXYT1VgoMIWU24KF-mYScg9PjL3TugAISQua539ugLmncN59wHv-AiFQR57jHm7GQk9p7oGUteG+B9y5cEQALKABJZgtDaDIfEbAo7lz9DCcuAAPWhOgq5hAvkUNu4Ij6CJPnkAooil43yGocFOe4t4gDDjgdYNskEVHIFzPED0HBmCjvwsSpD74+1AB-AkaxUAAIIUA4hwxNEgEsVdcW99w4yz8mVL0lt5GDkUbzZR6CQA70cSvMIDodHzDuKE9YXIzFDzsegFxawb7sM4TYkA3Cc6ZKLjCAuwYxaZKOtvBsg47hQBQV-MBN9jESISFI6AyQ4AAAoADkF9khtKbp0BgCBKBZQAJS1AAFS1ACBAFpTShjtLgmQLOg5um1F6f02e4MWoHTauMQZgyxECIadXCuSdWkdIKF0npFQ+kDJEsMsZd4pnHNmZnbOSyVmUDWTTBWWy4A7LbhAOYbBji0OOREtgKCc6kNATPfyZIb7-PvscAA6ooZQxSko3BvirJI1cj4gqQWC1BkKp5gIoTCr0mKaDYoAPJGDnO4cuJTu4YrkXGIJ-Q4C8OLr0cJ6BzJ3EqJyuJCTMmAK0ZUMgXM3AxO6mwt0HDD5ZNmDwzJdSK6SMOW8-hN9xFqoOTPS5-SFg3wFdY+pQiKEGveZaiBN9kiCIZUlSC2S25MFNlPecaL2roAQIoBQbsKXYodV6kAgwkBQBGnIq2rL3DBNyFnMJiDpHrySHcYWighX90SV0dAdtQg3wMXdDlaBNCKoCBk0AzqVVBrDGobV1avC1pkLw5omTj6HJEU2MZEyHnNKefMl5FzMBXI+THTZ9NfnapbWaqRHbRm1HudMk5cyFm5FeZakdEMx3mQnXEAFQLPXQxRLoTAwsmR-L3XAZFNR61oEaJG6NKiTUaJ5SAO2MSx5TwzeY-B2bX1mjzTIAtRi0A3FlWWhVlbQCqrbWEFps6ADUtQBC3PGXYHtMy2nLoHcs9d0dN0LwnDukAOqYPoDgzIpsiHkNzoXY8zDzzFmDuHXhjZBH2JEafZkshJK5b4cSu1W1R78w9EqP8gOTBJmLr7SutdQ7Vksfnvx7ZwyAB8zd671CaOsEpeQdB6B6jpoYXJUms1dV-WJvs9wTGsUc3t9H+2MZw3J95CnaZKZ+bUNTahtOOtsOonqombNSfszJpj8m55ucVux2oABeGLtRvMyB0z6kw-rWU6aYGwbAmbWHOMpTikYjrQ3hrbpzWYiK4B6dNYV4NmXp73r9jkWJL8X0JkqLkaVVov1ZsIZ0lNaaalgflVwpVOTQB5NyAU7RN7Sm7w65UuwM426qu42EZteyuNQvQG4ZocKL0zZCVV09Rrd0IsvSimAM3mVL0tkAA)

However, when I try to do the same with my index, I get an error when I try to calculate the average of it. The first aggregation part is the one creating the problem for me. When I remove that part I have my chart but its not calculating average, its giving every value.

What am I doing wrong? Please help!

```auto
"data": [
    {
      "name": "table",
      "url": {
        "index": "dashboard_data",
        "body": {"size": 10000, "_source": ["dv_survey","Rating","department_displayvalue","country"]}
      },
      "format": {"property": "hits.hits"} ,
  
      "transform": [
         {
          "type": "aggregate",
          "groupby": ["datum._source.department_displayvalue"],
          "fields": ["datum._source.Rating"],
          "ops": ["average"],
          "as": ["Rating"]
        },
       { "type": "filter", "expr": "datum._source.Rating > 0 && datum._source.Rating < 7 && datum._source['country'] =='Germany' " }
      ]
      
    },

    {
      "name": "keys",
      "source": "table",
      "transform": [
        {"type": "aggregate", "groupby": ["_source.department_displayvalue"] 
      
          }
      ]
    }
  ],

```

---

<div class="post-metadata">

**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\
**Post date:** [September 23, 2021, 1:05pm UTC](https://discuss.elastic.co/t/radar-chart-with-dynamic-data/285002/2 "2021-09-23T13:05:09Z")

</div>

If you can [provide the spec](https://www.elastic.co/guide/en/kibana/current/vega.html#asking-for-help-with-a-vega-spec) that will include some of your data and will be easier to troubleshoot it would be appreciated.

But on first glance I would try to remove the `datum.` part in your aggregate transform.

```auto
{
 "type": "aggregate",
 "groupby": ["_source.department_displayvalue"],
 "fields": ["_source.Rating"],
 "ops": ["average"],
 "as": ["Rating"]
}

```

---

<div class="post-metadata">

**Author:** ![bodach](https://avatars.discourse-cdn.com/v4/letter/b/a87d85/32.png) [@bodach](https://discuss.elastic.co/u/bodach)\
**Post date:** [September 23, 2021, 1:40pm UTC](https://discuss.elastic.co/t/radar-chart-with-dynamic-data/285002/3 "2021-09-23T13:40:19Z")

</div>

Hey Aaron,

I tried removing datum but then I got the error "Unrecognized signal name: "\_source" "

Here is the spec:  
[https://gist.githubusercontent.com/Bodach/489f80041dde90c110705cc0817ea200/raw/36fa891be97c7f05d83ae14be935e93aaa0fa7a3/bodach\_spec.json](https://gist.githubusercontent.com/Bodach/489f80041dde90c110705cc0817ea200/raw/36fa891be97c7f05d83ae14be935e93aaa0fa7a3/bodach_spec.json)

Thanks!

---

<div class="post-metadata">

**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\
**Post date:** [September 23, 2021, 2:38pm UTC](https://discuss.elastic.co/t/radar-chart-with-dynamic-data/285002/4 "2021-09-23T14:38:51Z")

</div>

I would try doing a project transform first to remove all the `_source` requirement from the fields then the rest of the visualization should work just like the demo. What that is doing is essentially just renaming the field to drop the `_source`.

You want to filter before aggregating. If not the filter fields won't be there after you aggregate. Transforms are from top to bottom so they process in that order.

Also I think you want to remove Japan. If not then you are only left with Japan which won't work. To write that you would change the `==` to `!=` like I did above.

```auto
      "transform": [
        {
          "type": "project",
          "fields": [
            "_source.dv_survey",
            "_source.Rating",
            "_source.department_displayvalue",
            "_source.country"
          ],
          "as": ["dv_survey", "Rating", "department_displayvalue", "country"]
        },
        {
          "type": "filter",
          "expr": "datum.Rating > 0 && datum.Rating < 7 && datum['country'] !='Japan' "
        },
        {
          "type": "aggregate",
          "groupby": ["department_displayvalue"],
          "fields": ["Rating"],
          "ops": ["average"],
          "as": ["Rating"]
        }
      ],

```

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/7/9733569fe2bb2dbc5558307501ecb3a8bdee57ec.png)

---

<div class="post-metadata">

**Author:** ![bodach](https://avatars.discourse-cdn.com/v4/letter/b/a87d85/32.png) [@bodach](https://discuss.elastic.co/u/bodach)\
**Post date:** [September 24, 2021, 9:21am UTC](https://discuss.elastic.co/t/radar-chart-with-dynamic-data/285002/5 "2021-09-24T09:21:29Z")

</div>

It works! Thank you so much!

---

<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:** [October 22, 2021, 9:22am UTC](https://discuss.elastic.co/t/radar-chart-with-dynamic-data/285002/6 "2021-10-22T09:22:15Z")

</div>

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