# Convert string to object and finding average

**URL:** <https://discuss.elastic.co/t/convert-string-to-object-and-finding-average/123714>\
**Category:** Elasticsearch\
**Created:** [March 13, 2018, 10:31am UTC](https://discuss.elastic.co/t/convert-string-to-object-and-finding-average/123714 "2018-03-13T10:31:27Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [March 13, 2018, 10:46am UTC](https://discuss.elastic.co/t/convert-string-to-object-and-finding-average/123714/2 "2018-03-13T10:46:15Z")

</div>

I would recommend restructuring how you model your data. Maybe breaking up the example you provided into multiple documents with the following structure during indexing could make querying easier?

```auto
{
  "StudentId": 1,
  "Marks": {
    "SubjectId": 1,
    "TotalTasksCount":15,
    "Result":73.3,
    "TestObjectsCorrect":64,
    "TestMaxPoint":15
  }
}

```

---

_[View the full topic](https://discuss.elastic.co/t/convert-string-to-object-and-finding-average/123714)._