Forum Discussion

ReneJamis1's avatar
ReneJamis1
Qrew Member
3 days ago

Stacked Column Chart Output

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...
reports
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 days ago

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"