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
------------------------------