Advanced set analysis

PapaJapa — Tue, 18 Jan 2022 07:53:10 GMT

Hello.

I analyze sales on ebay auctions. I have an auction list and a sale on them (by days [SalesDate]). Each auction has a start and end date (AuctionEndDate). I want to count auctions completed in a month that had sales in the last 7 days before the end.

I want to get a simple table with two columns:

month([AuctionEndDate]) and it is ok
count of auctions with sales in last 7 days

I tried with

count(DISTINCT {<[AuctionID] = {"=Sum({<[SalesDate]={">$(=date([AuctionEndDate]-7))"}>}[Sales])>'0' "}>} [AuctionID])

... but without success.

Please help 🙂

Thanks,

Re: Advanced set analysis

chris_djih — Wed, 19 Jan 2022 13:22:19 GMT

May i suggest to shift this problem into the script:

Just create a new Fields:

If(AuctionEndDate>=Date(Today()-7),1,0) as last7Days_Flag

then you can transform your Set-Analysis: Count(distinct {<last7Days_Flag={1},Sales={">0"}>} AuctionID)

topic Advanced set analysis in App Development

Advanced set analysis

Re: Advanced set analysis