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.
Qrew LegendMaybe 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"
I figured out that what I was trying to do isn't possible because a Stacked Column Chart does nnot have the Series option. The formula I'm sure would work, were this to be a Non-Stacked Chart, but at that point I could use my date field as the Series which is available in a Non-Stacked Chart.
Thanks for the assist on this.
I appreciate you.
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.
