On the old version of the app, it would allow you to tally up the sum of the components to display in the chart like so:
In the new version, there’s no way to automatically add it into the display:
Is there a way to create a sum on screen instead of in the database?
I could create it in the database, but there are a bunch of rows that I don’t want to be included in the tally and I’m not sure it’s possible to exclude them?
What was great about the adding the total on the chart was that it was already filtered for just the profiles I wanted to be included.
I think you would just have to do it in the database. The easiest way would be to create a Query column to mimic any filters you may have, and then do a Rollup on top of that Query.
1 Like
OK got it. I’ve never done a query so I’ll try that!
1 Like
Should also mention that you should be able to use the query as the source of your chart, so that way you don’t need to duplicate your filter logic twice.
1 Like
Yep, we are missing that old chart feature as well. It was much cleaner.
We achieved an alternative “Total” outcome the old school way by setting If-Then-Else columns to zeros and ones based on the cases (filtering) and then a couple of Rollup columns that Sum the values of those If-Then-Else columns. And finally set up a couple of Template columns… Total Registrants: x where x is the value of those Rollup columns.
We display that Template column as the Title field data of our charts. Never used the Query column. Probably would have saved a few steps. Will have to check it out.
3 Likes
we meet again! I’ll try the query and see if i can figure it out, the way I needed it done if then else’s weren’t working for me. I def miss some of the old features. I love that they added knew ones, but why take away the ones that were great!
3 Likes
A while back I created a feature request to enhance the donut chart. Maybe you could add your suggestions in that thread as well.
If Glide’s native chart components are too limited, have you considered QuickChart?
Looks like Glide has applied some slight style changes to their Radial Chart (removing the rounded pie slice edges that I rather liked), adding percentages of total on slice hover, and adding in a separate option to Show Values in Legend. Why not also give us Show Total in Center?
3 Likes
Can confirm that this style change for Radial went live today.
Here’s a feedback @NoCodeAndy .
1 Like
still feeling like my charts look really silly without a tally or something in the middle. Especially when there’s too much data to have a legend - just a blank circle.
@NoCodeAndy is there still a possibility of another update here?
How about using custom-collection and CSS?
Place the total in the value part of the Title and the class name of the radial-chart: center-chart.
.center-chart > div > div > div > div > div > div:nth-child(1){
height:0 !important;
margin:0 !important;
}
.center-chart > div > div {
border:none;
}
.center-chart > div > div > div > div > div > div:nth-child(1) > div {
position: absolute;
margin: 240px auto 0 auto;
left: 50%;
transform: translate(-50%, 0%);
}
3 Likes
Hi @Katelyn_Alberts
Put your total here:
Anda CSS code here:
2 Likes
Hi Himaladin! Im sorry I can’t find that section?!
Are you on the free plan? If you are on a paid plan, there should be a section for custom CSS.
1 Like
Or if you are on a Legacy Plan then it needs to be a Legacy Business or higher to get the Custom CSS panel.
1 Like
I am on a legacy business plan. it was before they came out with the most recent 4 tier options, but i’m paying $99 a month so i don’t know why i wouldn’t have it
Only the Legacy Business gets the CSS. The $99/ month Legacy Pro does not. Based on your early screen shots where it says Team in the top left corner in blue would lead me to think you are on a Legacy Pro plan vs. Legacy Business. If you back out to the Dashboard showing all of your apps, what does it read in the top left in blue?
A Legacy Business app should read Business at the individual app editor level where your screen shot is showing Team. I wish they extended the CSS to Legacy Business and Legacy Pro but no such luck.
1 Like
oh i see, im on legacy pro, i forgot about that difference, i just knew it wasn’t the free one. thats a bummer, it’s still not cheap. however my empty charts look cheap lol
1 Like
Our circular charts feel a bit bare these days as well compared to our older Classic app. But thankful to Glide for allowing us to hold onto our Legacy status!