how to make rowno with aggr for grouping data

[marjan_it]

Hi all

I have a chat with  like this that have some filed. Messageid , Messagelogid, from date and to date. I want to add row no for each messahe id like the sample.

Messageid	Messagelogid	fromdate	to date	row no
1	1	2013-10-23	2013-10-23	1
1	2	2013-10-23	2013-10-224	2
1	3	2013-10-24	2013-10-25	3
2	4	2013-10-23	2013-10-25	1
2	5	2013-10-25	2013-10-29	2
3	6	2013-10-25	2013-11-25	1
3	7	2013-11-25	2013-11-27	2

how can I built rowno in chart?!!

[antoniotiman]

May be this

Autonumber(RowNo(),Messageid) as rowno

Regards,

Antonio

[marjan_it]

No it dosnt work

[antoniotiman]

Why ?

LOAD *,AutoNumber(RowNo(),Messageid) as RowNo Inline [
Messageid,Messagelogid,fromdate,to date,row no
1, 1, 2013-10-23,2013-10-23, 1
1, 2,2013-10-23,2013-10-224, 2
1, 3,2013-10-24,2013-10-25, 3
2, 4,2013-10-23,2013-10-25, 1
2, 5,2013-10-25,2013-10-29, 2
3, 6,2013-10-25,2013-11-25, 1
3, 7,2013-11-25,2013-11-27, 2
];

[marjan_it]

H want something work in expression not in script.

[prma7799]

Hi @antonio,

She wanted to this in front end ....

Thanks

[antoniotiman · Accepted solution]

Try this

Aggr(RowNo(),Messageid,Messagelogid)

[marjan_it]

thats work so good. thank you