Cummulative values in charts

[eurogar]

Hi! My Users have a field called “priority” (number from 0 to 1). I want to display a chart (e.g. using amCharts) that shows in the horizontal axis the priority in 10 groups (from 0 to 0.1, from 0.1 to 0.2, etc.) and in the vertical axis the number of occurencies of such priority as a number.

So if I have 2 Users with a priority of 0.4 and 3 Users with a priority of 0.7, I want to display 2 bars:

• One bar with a hight (vertical axis) of 2 and the label (horizontal axis) equals to 0.4
• One bar with a hight (vertical axis) of 3 and the label (horizontal axis) equals to 0.7

How should I build this in a (free) chart plugin?

Thanks a lot!

[dan1]

Are you familiar with the Grouping and Aggregating Data functions? You may be able to set this up using those functions.

See this thread below, a good bit of helpful information there.

[New Feature] Grouping and Aggregating Data

Hi all, We’ve heard from many of you that you’d like an efficient way of displaying your app’s data in a chart or table. For instance, maybe you’d like to be able to show a graph of new user signups by month, or show a table of total sales by region and account. We now have a tool for supporting this kind of operation. It’s called “:group by”, and you apply it on top of a search or other list of data items in order to group and summarize the list. [group%20by%20screenshot] The basic conce…

[eurogar]

Thanks a lot, @dan1! That fixed my problem! Really appreciated!

[dan1]

Glad it helped get you going in the right direction.