# Accessing different properties inside groupings for chart

**URL:** <https://forum.bubble.io/t/accessing-different-properties-inside-groupings-for-chart/146873>\
**Category:** Database\
**Created:** [April 18, 2021, 12:32pm UTC](https://forum.bubble.io/t/accessing-different-properties-inside-groupings-for-chart/146873 "2021-04-18T12:32:02Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![getchukka](https://avatars.discourse-cdn.com/v4/letter/g/aeb1de/32.png) [@getchukka](https://forum.bubble.io/u/getchukka)\
**Post date:** [April 18, 2021, 12:32pm UTC](https://forum.bubble.io/t/accessing-different-properties-inside-groupings-for-chart/146873/1 "2021-04-18T12:32:02Z")

</div>

Hi, I have a question regarding grouping.

I am using the plugin ApexCharts.js by Thimo and am struggling to display my data on an area chart how I would like.

The chart will have 2 series. Series one will count the number of quotes with status as ‘sent’ and the second series will count the number of quotes with status ‘converted’.

On the X axis I want dates to show how many numbers of quotes for each series for a certain day. e.g. If there are 2 sent quotes and 3 converted quotes on 23rd May then on the 23rd may series one will line up with 23rd May / 2 and series 2 will be 23rd May / 3.

I am struggling with the grouping to get this to show.

Any help would be appreciated.

Cheers.

 ![Screenshot 2021-04-18 at 13.26.59](https://us1.discourse-cdn.com/bubble/original/3X/d/4/d48775508471ce4856eda6d88352d906f25cdc34.png)

---

<div class="post-metadata">

**Author:** ![cmarchan](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/cmarchan/32/253062_2.png) [@cmarchan](https://forum.bubble.io/u/cmarchan)\
**Post date:** [April 18, 2021, 5:49pm UTC](https://forum.bubble.io/t/accessing-different-properties-inside-groupings-for-chart/146873/2 "2021-04-18T17:49:15Z")

</div>

Both the categories and the data need to have the same expression for the plugin to work. Essentially the same grouping logic. Check with @Thimo the plugin’s author for further guidance in case you continue to face difficulties. Thimo is super-supportive! 😀

---

<div class="post-metadata">

**Author:** ![getchukka](https://avatars.discourse-cdn.com/v4/letter/g/aeb1de/32.png) [@getchukka](https://forum.bubble.io/u/getchukka)\
**Post date:** [April 18, 2021, 5:52pm UTC](https://forum.bubble.io/t/accessing-different-properties-inside-groupings-for-chart/146873/3 "2021-04-18T17:52:09Z")

</div>

Hey Cmarchan cheers for your reply, do they not have the same expression in the screenshot above?

I had given Thimo a message but I don’t think I explained myself well enough, he was a great help for my other questions but he wasn’t too sure about this one 🙂

---

<div class="post-metadata">

**Author:** ![cmarchan](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/cmarchan/32/253062_2.png) [@cmarchan](https://forum.bubble.io/u/cmarchan)\
**Post date:** [April 18, 2021, 6:00pm UTC](https://forum.bubble.io/t/accessing-different-properties-inside-groupings-for-chart/146873/4 "2021-04-18T18:00:40Z")

</div>

Rebuild from less to more the complexity of the grouping. Try to get some data to show and adjust from there on.

---

<div class="post-metadata">

**Author:** ![jared.gibb](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/jared.gibb/32/123329_2.png) [@jared.gibb](https://forum.bubble.io/u/jared.gibb)\
**Post date:** [April 18, 2021, 6:07pm UTC](https://forum.bubble.io/t/accessing-different-properties-inside-groupings-for-chart/146873/5 "2021-04-18T18:07:31Z")

</div>

Try printing that expression to a label and see what it looks like. Could be incorrectly formatted even though it’s being accepted.

That could help reveal an underlying issue of mismatched data or something else.

---

<div class="post-metadata">

**Author:** ![getchukka](https://avatars.discourse-cdn.com/v4/letter/g/aeb1de/32.png) [@getchukka](https://forum.bubble.io/u/getchukka)\
**Post date:** [April 18, 2021, 6:53pm UTC](https://forum.bubble.io/t/accessing-different-properties-inside-groupings-for-chart/146873/6 "2021-04-18T18:53:39Z")

</div>

Cheers mate! Instead of grouping by Status and Modified date, I only needed to group by modified date as a I had already predetermined the status in the search criteria.

Thanks
