Stacked Bar Chart
Hello, Team. It's been a minute. Thank you for all the help the last two months. Need help with a stacked bar chart.
It currently shows like this...
I need it to reflect the % of the...
Forum Discussion
That option is checked (the values are displayed). And "percent of series" is checked. But again, that is the root of the problem. I don't want it to be a Percent of Series. I want it to be a percent of the year. (Not the years.) i.e. In a given year, if we collect $500,000 of River Fees. I want to show the City collected 30% of that and Outfitters collected 70% of that $500K, as an example.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------
Sorry, I didn't zoom in on your top picture and made an assumption the top picture was values. Let me think about your ask.
------------------------------
Mike Tamoush
------------------------------
No worries, Mike. But, I just got it solved. I think I knew this last night, it was just a long day and I needed to go home. Your reply prompted me to get back to this. I created some summary variables and the corresponding formulas.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------Hah, I posted 30 seconds after you. Looks like we came up with the same solution.
------------------------------
Mike Tamoush
------------------------------Thanks, Mike. I love it. I will chalk it up to tired head last night and still being a little new to the concept of Summary Variables and Reports. They are obviously VERY powerful, just gotta get more confident in the usage of them.
I appreciate the time you spent to respond. It's a great piece of this entire solution that this forum has such helpful members.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------