Skip to Content
0
Nov 28, 2022 at 09:45 PM

SAC - Distinct count of two different date columns - Logic

171 Views

Hello,

I have a scenario as below, and trying to find the best way to achieve it in a SAC story

An example of Source data

image.png

Required Output in SAC table

The output is counting the number of rows which has the 'start date' in a particular month and 'closed date' in a particular month

image.png

If you have come across a similar requirement before, please provide your input.

Attachments

image.png (5.9 kB)
image.png (3.8 kB)