need help

[#1]

Hi Comunity,

I want to evaluate distinct count of ids

My desired output should be like this

date, id

1-Jan, 10

2-Jan, 15

3-jan, 20

any help?

See below attached for your reference.

[Colin-Albert]

Load the data, then create a straight table chart with date as a dimension, and count(distinct id) as the expression.

[#3]

Yes! I tried the same but no result as am exactly looking for

It shows only,

1-Jan 10

2-Jan 20

3-Jan 30

Any more ideas?

[Kushal_Chawda]

LOAD Date,

          Count(ID) as Id_Count

FROM Table

group by Date;

[#5]

No...In Script & UI I tried the same before posting.

But no use.

[sunny_talwar · Accepted solution]

May be using a flag:

Table:

LOAD id,

    date

FROM

doubt.xlsx

(ooxml, embedded labels, table is Sheet1);

FinalTable:

LOAD id,

  date,

  If(id = Peek('id'), 1, 0) as Flag

Resident Table

Order By id, date;

DROP Table Table;

[#7]

This is exactly what I looking for,

Thanks Sunny!!!!