Forum Documentation Showcase Pricing Learn more

Doughnut Chart Issues

#1

Hello Community!

Overview:
I’m working on creating Doughnut charts to display data and running into a weird issue. I have two separate forms that enter data into the same database (An academic form and a behavior form). I have two boolean values to indicate which form. I had to do two separate forms because in the future I’ll have multiple forms going into the same database.

The Problem:
I was trying to do a count of Academic and behavior submissions for a specific student. When I set it up, I’m getting a separate section for each submission even when they are both “yes” in the database. It looks like this.

And my configuration is like this:

Any ideas would be helpful!!!

#2

Hi Josh!

You might consider tracking your form type in a single field, rather than two booleans. Then you can use the group by operation to get the count of each form type. This gives you scalability as well as adding a new form type would not require any changes to you code – you just add a new value into the text field (or a separated data type if that becomes more appropriate.)

Hope that helps!

–Ken



Looking to accelerate your app development?

Development of Advanced Apps at https://uniqueideas.com or schedule a free intro session :gift:

Ken Truesdale
LinkedIn

2 Likes
#3

I’m going to try that in just a few minutes! Thanks for the recommendation.

#4

Just wanted to say thanks @mebeingken! You truly helped me here! It worked perfectly.

1 Like
#5

Appreciate the feedback Josh, glad it helped!