Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
Load the data, then create a straight table chart with date as a dimension, and count(distinct id) as the expression.
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?
LOAD Date,
Count(ID) as Id_Count
FROM Table
group by Date;
No...In Script & UI I tried the same before posting.
But no use.
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;
This is exactly what I looking for,
Thanks Sunny!!!!