Forum Discussion

MattMakris's avatar
MattMakris
Qrew Cadet
4 years ago

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

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
------------------------------

2 Replies

  • 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
    ------------------------------
    • MattMakris's avatar
      MattMakris
      Qrew Cadet
      Thank you. It was right in front of me 🤦‍♂️ lol

      ------------------------------
      Matt Makris
      ------------------------------