weekly | DevComm-Shanghai Weekly 上海地区高校技术社团联合周报（欢迎投稿） | Blog library

I think you want a column chart, like this

I suggest that you use Sheet.getRange(row, column, numRows, numColumns) and Range.getValues() to get the row values with multiple columns.

Sample:

Your goal is possible by using a custom script. You can try creating a bound script in your spreadsheet file and copy/paste this sample script below:

[updated]

SCRIPT:

If I understand correctly, it is the total row that you really care about. You can calculate the first two columns by unnesting both tags and payments in parallel.

Then for the total, unnest the payments without the tags:

Since MS Access reports are specialized rich text formats, conversion to HTML is not easily available. You would need to rebuild your report with HTML markup. However, there is another approach.

Consider creating an Outlook email template (.oft) with all needed images, colors, fonts, and other formatting with placeholders such as %...% markers:

Dear %ClientName%:

Thank you for purchase of %product% for %totalsales% on %salesdate%. We appreciate your business of %years% years.

%salestable%

Best wishes,
MyCompany Management

Then, have MS Access loop through a recordset of email details and text for message body to fill in placeholders. Handle any date/current/percent formatting in SQL or VBA. Because you need a group level multi-record summary, run two loops at 1) client level and 2) sales level.

It seems the first value is the epoch time in seconds (number of seconds since 01/01/1970) (unix time / posix time)

Try groupby size on both pd.Grouper and item (use Anchored Offset to set Saturday to Saturday weekly):

You should use the Azure feature for the automated backups.

If you setup using the azure webapp, be aware that you can find the backups option at the server (and not at the database) level.

For the retention policies and the frequencies you can look into the Microsoft documentation which is well written.

The secret to the solution here is that BYMONTHDAY can be negative like BYSETPOS. This allows one to exclude the last 7 days of each month even though the number of days in the month varies. Your DTSTART should be on a SATURDAY, so one doesn't really need the BYDAY=SA

This rrule works in google calendar (if DTSTART is on Saturday and generally for any every 2nd week but not the last week rule for any day of week specified by the DTSTART):

RRULE:FREQ=WEEKLY;INTERVAL=2;BYMONTHDAY=-8,-9,-10,-11,-12,-13,-14,-15,-16,-17,-18,-19,-20,-21,-22,-23,-24,-25,-26,-27,-28,-29,-30,-31

See test calendar: https://calendar.google.com/calendar/u/0?cid=ZXBwdWE4N2RwZm5xODVic3JydDJzaXFsY3NAZ3JvdXAuY2FsZW5kYXIuZ29vZ2xlLmNvbQ

Spec: https://datatracker.ietf.org/doc/html/rfc2445#page-43

and https://icalevents.com/2447-need-to-know-the-possible-combinations-for-repeating-dates-an-ical-cheatsheet/ for the expansion & contraction (limiting) rules & combinations