# Can Reports BINS() function show record counts grouped by a field SUM?

**URL:** <https://community.fibery.io/t/can-reports-bins-function-show-record-counts-grouped-by-a-field-sum/4898>\
**Category:** Get Help\
**Created:** [August 3, 2023, 3:45pm UTC](https://community.fibery.io/t/can-reports-bins-function-show-record-counts-grouped-by-a-field-sum/4898 "2023-08-03T15:45:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [August 3, 2023, 3:45pm UTC](https://community.fibery.io/t/can-reports-bins-function-show-record-counts-grouped-by-a-field-sum/4898/1 "2023-08-03T15:45:13Z")

</div>

I’m trying to use a VizyDrop Color Rule to visualize the relative count of records in each group created by the `BINS` function.

`BINS` is generating its groups for a field `SUM`, but I’m interested in showing the count of records in each `BIN`, not the field `SUM`s of the records in each `BIN`.

* * *

Here’s what **does** work: the X-axis shows the `SUM()` of the `[Call Duration (in seconds)]` field, which is the total duration of one salesperson’s calls records:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/d/d0f918d4b0c2af64d6ae9f41cc1d6a2cc4d46b1f.png)

This Color rule uses `BINS` to show the relative subtotals of the various ranges of call durations:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/7/70e1230ae718cf7b67d93a83e980c6573711492c.png)

I’d like to create a variation where the X-axis shows the `COUNT` of Call records instead of the `SUM` of Call durations, and the BINS. I still want `BINS` to group the records by Call-duration as before, but now **I want the X-axis and the BIN lengths to show record-counts (how many records are in each BIN).**

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/7/728e8a582321ca5384cc3949dff5e2d79351c710.png)

* * *

Is this possible?

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [August 4, 2023, 8:12am UTC](https://community.fibery.io/t/can-reports-bins-function-show-record-counts-grouped-by-a-field-sum/4898/2 "2023-08-04T08:12:29Z")

</div>

Maybe I misunderstand, but won’t it be fine if you choose `Count([Id])` for the x-axis  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/0/0317b17fb1a1349f7cbcab4417aa9b9043acbc42.png)

and then `BINS([Duration], x)` for the color coding (where x is the number of bins you want)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/f/fc07e5be73925f18a59d3527900685f2f1d808dc.png)

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/1/1d335e59b9dc15647cd82e31a8050d11246f9010.png)

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [August 4, 2023, 3:14pm UTC](https://community.fibery.io/t/can-reports-bins-function-show-record-counts-grouped-by-a-field-sum/4898/3 "2023-08-04T15:14:53Z")

</div>

Thanks @Chr1sG – that works 😀 👏

Here’s another chart question – when I have multiple axes on a bar graph, is there a way to specify independent scales for each?

E.g. one set of values has a range 0 - 1, and the other set of values has a range 0 - 100. Since they are both displayed with one scale, the smaller set of values is all lost near the left edge of the chart.

Is there a way to specify the scale independently for each axis (other than manually scaling the values)?

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/9/91e0ceaeffd49c94b3014e220fa58c09749e06f7.png)

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [August 4, 2023, 4:06pm UTC](https://community.fibery.io/t/can-reports-bins-function-show-record-counts-grouped-by-a-field-sum/4898/4 "2023-08-04T16:06:36Z")

</div>

AFAIK no, it’s not possible to have multiple x-axes, each with a different scale, sorry.