How to make a histogram widget
Hi.
I want to create a widget that gets me the frequency (distribution) of a number given a formula.
How can I create this, the Histogram plug in doesn't work.
Thanks,
Javi.
Forum Discussion
8 Replies
Hello
If the Histogram plugin isn’t working, you can mimic a histogram using a bar chart. Just create a custom formula to bucket your numeric field into ranges (e.g., FLOOR([Value]/10)*10 for 10-unit bins), then use a count aggregation to show frequency per bin. 🙂Plot this on a bar chart with the bins on the X-axis and count on the Y-axis. This gives you a functional histogram without needing a plugin.
Thank you!!😊
Hi vatojavier​,
Thank you for reaching out. Does the solution offered by gabrielladawn​ address your question?
Hi, thanks for the help but for a Bar Chart, I can't place any computation in the y-axis (Categories)
Depending on what you're trying to count, you might not need to have anything in the Y-Axis/Category at all. What gabrielladawn​ was suggesting is manually creating multiple separate formulas under the Values section, one for each range/bucket you want to show as a bar.
Here's something similar I did in my system, using a Column Chart instead of a Bar Chart:
Here's what the widget setup looks like:
Each one of those Values is a formula I created. Here's what the first one looks like (the rest are pretty similar, just swapping out numbers where appropriate):
The only thing that stinks about this method is the manually creation of each bucket. If you want a LOT of buckets then that needs a lot of formulas, and the ordering of them is also entirely manual. I'm guessing that's what the Histogram plugin is supposed to do, it probably just automates this process so you can dynamically increase or decrease the number of bars shown.
Hello vatojavier​,
Thank you for reaching out. I see your question hasn't gotten a response yet, so I'm asking internally to try and get you an answer.
Hi vatojavier​ !
Could you please clarify if you're using this add-on? If so, please describe your challenge with this add-on.
Regards, Lily
vatojavier​ were you able to chat with Liliia_DevX​ ? We are here if you are still needing assistance!
Hello vatojavier​ ,
I’m following up to see if any of the solutions offered worked for you.
If so, please click the 'Accept as Solution' button on the appropriate post. That way others with the same questions can find the answer. If not, please let us know so that we can continue to help.
Thank you.
