Grouping on an additional variable in Spotfire

[Dragomir Kyosev]

I have data on report views per user and respective date of viewing it and would like to calculate the number of new users (i.e. those that accessed a report for a first time in the current month, in this case being Oct 2020) viewing each report.

User Report Date Accessed

1 X 01/09/2020

1 X 01/10/2020

1 Y 02/10/2020

2 X 01/10/2020

2 X 02/10/2020

2 Y 03/10/2020

Would like to get to this point:

Report New Users

X 1

Y 2

Trying with the following code but I realize there is something wrong with the aggregation logic on User. I already have Report as an aggregation column in my cross-table:

UniqueCount(If(Min[Date Accessed] over [user]>=Date(Year(Today()),Month(today()),1),[user]))

Thank you!!!

[Fabian Duerr]

I have created two calculated columns in my solution.

The first one checks if the Month of your 'Accessed Date' is equal the current month. And the second column counts the occurences per moth, report, user.

To get only the first time users filter this column to the value 1.

PS: I'm not sure if your sample data is supposed to be in Sep/Oct... I changed it in my report to Sep/Oct to be able to make the comparison to the current month. It's important to have dates in the format mm/dd/yyyy when importing data to Spotfire