Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Object_Type | Object_ID | DATE |
---|---|---|
AAA | 1 | 01/01/13 |
AAA | 2 | 01/01/13 |
AAA | 3 | 02/01/13 |
AAA | 2 | 05/01/13 |
AAA | 1 | 05/01/13 |
BBB | 1 | 01/01/13 |
BBB | 2 | 01/01/13 |
BBB | 3 | 01/01/13 |
BBB | 4 | 01/01/13 |
BBB | 4 | 02/01/13 |
Object_Type | DATE | Count(Object_ID) |
---|---|---|
AAA | 01/01/13 | 2 |
AAA | 02/01/13 | 1 |
AAA | 05/01/13 | 2 |
BBB | 01/01/13 | 4 |
BBB | 02/01/13 | 1 |
Object_Type | DATE | Count |
---|---|---|
AAA | 01/01/13 | 2 |
AAA | 02/01/13 | 1 |
BBB | 01/01/13 | 4 |
Hi,
Do you have any condition to filter the data in table.
Hi Kumar
I dont have any conditions.
BR
Ariel
Are you want to dispaly maximum date for object type or what ?. I am confused with the final output table you provided .
Hi Jain,
I want to count only the first value in the table.
For example Object_Type = 'AAA' , Object_ID=1 it appeared 2 times in the table (01/01/13, 05/01/13)
I want to count him only in the date 01/01/13 and discard him in 05/01/13.
BR
Ariel
To count up the number of entries appearing on the first date that a Object_Type occured, something like this might work as an expression, with Object_Type as the dimension:
count(if(DATE=min(DATE),Object_ID)
or using set analsysis:
count({<DATE={'=min(DATE)'}>} Object_ID)
For the date column, you could then use:
only(if(DATE=min(DATE),DATE)
Jonathan
Hi Jonathan
Thanks for your answer but it dosn't work.
Seems you need to calculate the minimum date across each type. Try:
count(if(DATE=aggr(NODISTINCT min(DATE),Object_Type),Object_ID))
See attached.
Jonathan
Hi Jonathan
Still not good.
in your QVW the table contain 1 date (01/01/2013) with 2 types (AAA,BBB) but should have 2 dates (01/01/13,02/01/13) - see the table above.
Like Sunil, I'm confused about the decision of what dates to output.
How do you decide to output AAA on 02/01/13 ?
Jonathan