Skip to main content
Question

How to calculate the date of the first day of the week of a date

  • May 8, 2020
  • 0 replies
  • 44 views

MattMakris
Forum|alt.badge.img+7
I am trying to create a line chart report that charts weekly sales progress in a chart in a table that records the sales numbers daily. How would I plot "Week of mm/dd/yyyy" on the X axis of the line chart? Thanks!

Here is what the chart presently looks like with each day in the X axis:


------------------------------
Matt Makris
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • May 8, 2020
np,
Set he report to group the date "by week" instead of "by day".

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