Summary Formulas vs Variable Formulas
Not sure which one I need here, or if there is another way of doing this. Have a table with Fire Calls, types are Fire and Ems. I need to show both on a chart, which I have already done. I need a ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendHave you considered doing a stacked bar chart instead? Maybe with the X axis being the date grouped by months. Then make the series the type?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Mark,
Thought I replied last night. I have. In fact, that is how I have one graph setup. But, I also am wanting to showcase the flexibility of reporting/graphing within QB. So I was hoping to be able to show it the other way as well. Screenshot attached of the Stacked bar Chart.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------- MarkShnier__You
OK, thy this.
Make a formula field called [Fire Calls] that calculates to 1 if it's Fire
If([Type]="Fire", 1)
Then same for EMS
If([Type]="EMS", 1)
Then also a formula [Total calls] but the formula is just 1.
Then make a bar chart and when you hover near right the first selection for [Fire Call], you can add another bar choice for [EMS calls] and again for [Total Calls])
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------You lost me here, Mark.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------
Just thought of another way to do this. Can I auto create a record that would sum two other records? Meaning, if someone enters a data point for Feb 2024 with call type EMS, then a new record is automatically created with call type monthly total that would add # of calls for EMS+# of calls for Fire?
I say auto-generated, because otherwise I would have to precreate that record, so to speak. I still don't talk correct developer language here, so I am attempting to explain my desires/thoughts from a Manager's perspective.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------- MarkShnier__You
Where did I lose you?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------That formula "seems" to accomplish a COUNT of the type of calls. or something I an completely missing. Maybe a screenshot of my table would be helpful here.
I guess I can just accept that the way I need to go here is to add another [Call Type] such as Total and just have the user enter it. I can see where this leads to possible data entry issues, but I just can't work out how I can do it otherwise. I just have a nagging feeling SmartSheet can do this, I just can't figure it out.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------
