Forum Academy Marketplace Showcase Pricing Features

Cummulative values in charts

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!

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.

1 Like

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

Glad it helped get you going in the right direction. :slight_smile:

1 Like

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