Hi folks, below my simple table
| Table1.Date | Table2.Field | New Defects | firstsortedvalue(Date,Date]) |
| 20200120 | New | 1 | 2020-01-20 | | |
| 20200127 | New | 1 | 2020-01-27 | | |
| 20200203 | New | 1 | 2020-02-03 | | |
| 20200210 | New | 1 | 2020-02-10 | | |
| 20200217 | New | 1 | 2020-02-17 | | |
| 20200224 | New | 1 | 2020-02-24 | | |
Please Notice that i have two fields from different table and i need just to count first appearances
What i did:
COUNT({
[FLAG_NEW] = {'New'},
[Date] = {"=firstsortedvalue(floor([Date]), floor([Date]))"}
>}DISTINCT [%WorkItem])
//Option 2
count(Aggr(
If(FirstSortedValue(Date_FLoor, -Date_FLoor) = Floor_CreatedDate, 1, 0)
, [%WorkItem]))
Still doesn't work 😞
Second Option is working but when i select specific bar it's stop working because i used aggr()
Expected result
| Table1.Date | Table2.Field | New Defects | firstsortedvalue(Date,Date]) |
| 20200120 | New | 1 | 2020-01-20 | | |
| 20200127 | New | | 2020-01-27 | | |
| 20200203 | New | | 2020-02-03 | | |
| 20200210 | New | | 2020-02-10 | | |
| 20200217 | New | | 2020-02-17 | | |
| 20200224 | New | | 2020-02-24 | | |
