Skip to main content
Question

Charts and reports that start in August instead of January

  • November 25, 2020
  • 0 replies
  • 28 views

Forum|alt.badge.img+5
Hello All,

I have a vendor contract that starts in September, so I need to show the data from September to August of each year.  (see below for example)  Each time I create a report or chart (line chart) they all start from January to December.  Is there a way to select a start month for a summary reports/charts?  I am still in need of reports from Jan - Dec but this particular vendor is from Sept to Aug.

September

October

November

December

January

February

March

April

May

June

July

August

2019

2020


Thank you in advance.

------------------------------
Jennifer Silberstein
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
You will need to a text formula field called perhaps like [Vendor XYZ month]  and cheat on the month names to coax them to sort alpha.

Case(Month([date field],
9, "01-Sept",
10, "02-Oct",
11, "03-Nov",
12,"04-Dec",
1, "05-Jan",
et
8,"12-Aug")

Then group by that field instead of the date field.





)

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------