Skip to main content
Question

Stacked Column Chart Output

  • March 6, 2025
  • 0 replies
  • 125 views
Forum|alt.badge.img+2

Hello Everyone,
I created a SCC where the X Axis shows Supervisor Name and the Y Axis shows a stack of 5 different Formula Fields we'll call CB1, CB2, etc.

My Filters are set to Status = Approved AND
Eval Date Is During the Current Month.

The chart can shows up to 5 columns 1 per Sup.

What I want to do is create the chart to show 2 columns for each Sup. where 1 is data from the Prev. Month and the other for Current Month. 

Any help would be greatly appreciated.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • March 6, 2025

Maybe try making a formula field to labbel the records into "Current Month" and "Last Month" by a formula.

 

such as

IF(

FirstDayOfMonth(Today()) = FirstDayOfMonth([MyDate Field]), "Current Month",

FirstDayOfMonth(AdjustMonth(Today(), -1)) = FirstDayOfMonth([MyDate Field]), "Current Month", "Last Month")

Then open up the report to Eval dates in the last two Months and use that calculated field as the "Series"

 

 

 

Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+2
  • ReneJamis1
  • Author
  • Quickbase Alumni
  • March 11, 2025

I figured out that the reason I can't do what I'm trying to do is b/c of the chart type.
Stacked Charts don't have the Series option available to them.
I created a Prev. Month & Curr. Month report and set them side-by-side.  That works for now.  

Thanks for the assist on this.
I appreciate you.

Terms & ConditionsAccessibility statement