expression change

[#1]

hi guys,

Dimension is : =Aggr(Date(Floor(DATE),'DD/MM/YY'),TicketNumber)

Expression is:

=Count({$<ID={1},TYPE={'In','Ext','Out'}>}1)

The above combination is giving perfect result out put as "total count of first id of ticket number" by date,but i need last id of ticket insted of first id number, last id will not be constant.

can u suggest some thing for that expression?

thanks

[sunny_talwar]

Not sure what you trying to do, would you be able to share a sample?

[#3]

hi,

i'm trying to count number of tickets by date for max_id/latest_id and type of ticket is should be 'In',ext, or out.

I'm looking some thing like the belwo output:

Input
Date	Ticketnumber	Type	id
1/12/2015	100	In	1
1/12/2015	100	In	2
1/12/2015	101	out	1
1/12/2015	101	out	2
1/12/2015	101	out	3
1/12/2015	200	ext	1
1/12/2015	200	ext	2
1/13/2015	200	ext	3
1/13/2015	200	ext	4
1/15/2015	300	ort	1
output
Date	count
1/12/2015	3
1/13/2015	1

thanks

[#4]

any help?

[sunny_talwar]

Are you over complicating things? May be you just need this:

Dim: Date

Expression: =Count(DISTINCT{<Type={'In','ext','out'}>} Ticketnumber)

[#6]

hi,thank for this.

I do not think DISTINCT will take max id for the above suggested expression calculation.

am i right? else pls correct.

[sunny_talwar]

It won't, but not sure why you want to count just the max? the result should still be the same, isn't it?

[#8]

yes,tht's right...In real time data will come different ways there is possibility..so i need to focus on only max one.

thanks for your help.