# Sort and Chart data

**URL:** <https://forum.bubble.io/t/sort-and-chart-data/13236>\
**Category:** Need help\
**Created:** [May 8, 2017, 5:59pm UTC](https://forum.bubble.io/t/sort-and-chart-data/13236 "2017-05-08T17:59:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![aliandrihab](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/aliandrihab/32/18281_2.png) [@aliandrihab](https://forum.bubble.io/u/aliandrihab)\
**Post date:** [May 8, 2017, 5:59pm UTC](https://forum.bubble.io/t/sort-and-chart-data/13236/1 "2017-05-08T17:59:22Z")

</div>

Hello Friends,

I’m having a hard time sorting (bubble sort - he he) data and displaying in a graph. The data is stored in three separate columns… looks something like this:

![](https://us1.discourse-cdn.com/bubble/original/2X/4/44cfd17916b8ca48f089d9ff15c82e8ef5b483ce.jpg)

So the end goal… is to have this data in a format that i’m able to use in a stacked bar graph. I’m using google charts (open to other ideas) to do this. The format is: [Date, sumCatagory1, sumCatagory2, sumCatagory3, sumCatagory4, sumCatagory5] or basically:

![](https://us1.discourse-cdn.com/bubble/original/2X/4/4393b90df48fcc5a7a64fb6732d7924932ff3055.png)

So for the data shown above the graph would look like this:

 ![](https://us1.discourse-cdn.com/bubble/original/2X/4/4c5ede31381704b93ca187caffbe98ff653257b0.png)

The farthest I’ve gotten is identifying how many unique elements there are in the date code… I did some ‘googling’ and saw that i can write some for loops etc… that can’t be the only way…can it ?

Thanks in advance

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/bubble/original/3X/2/8/2847faa74692c2ffa5d939d3dc3724cdd060d247.png) [@system](https://forum.bubble.io/u/system)\
**Post date:** [July 17, 2017, 6:06pm UTC](https://forum.bubble.io/t/sort-and-chart-data/13236/2 "2017-07-17T18:06:34Z")

</div>

Closed on July 17, 2017, 6:06pm UTC

This topic was automatically closed after 70 days. New replies are no longer allowed.