Hello community,
I am looking for assistance with creating a report (either pivot or multi-pivot) from a single table that shows the number of records created last week in one column and the number of records closed last week in another column. I can't use state because it is possible for the record to be both created and closed in the same week, so they need to be counted under both columns. The Created date and Closed date have timestamps, which SN then creates columns for each timestamp. The only solution that I have heard to this point is that I need to create another filed on the table that simply contains the date.
Please let me know if you can think of anything else, which may help.
Thanks in advance!
