SetAnalysis Date Help

[Vittore8]

Good day, please tell me how i can get count: 2

rezult: 2 because, this date 01.07.2020 included in the range and there is a Work status

[Kushal_Chawda]

Can you please elaborate?

[Gabriel]

Hi,

Am not sure I understand well your request, however, try suggestion below.

Example data

tmp:
LOAD Start_Date,End_Date,Status,
IF(Status='Work' AND Start_Date <= DATE(TODAY()) AND End_Date >= DATE(TODAY()),1,0)
AS [Flag_Include]

INLINE [

Start_Date,End_Date,Status
01/01/1999,02/02/2030, Work
12/10/2000,19/04/2044, Work
12/11/2005, 20/06/2050, No-Work
];

In UI drag & drop table object

DIMs: Status, Start_Date, End_Date

Expression:  =COUNT({<Flag_Include={1}>} Status)

Hope this helps