remove duplicates while taking sum.

[#1]

Hi All,

Hope you had a great weekend.

Here I am with a new set of problem.

I have attached an excel with this email with the data set.

The problem is

I have duplicate item Id. So how do I remove the duplicates?. My final aim is to total the Design - Create date and count the unique Item Id and then find the average.

But here because of the duplicate item ID, I also have extra amount in my total. How do i remove the duplicates and there influence in the total.

please help,

Thanks a lot,

Regards,

Bikash

[#2]

Yes, I am using the group by, this way,

Load

ITEM_ID,

max(MODIFIED_DATE) as MaxDate

resident (mytable)

Group by ITEM_ID ;

[Clever_Anjos]

This code wouldn´t duplicate data.
Where do you see your duplicate data?
A Graph? Which Dimentions are you using in it?

[#4]

I am seeing that in a table box. 😞

[Clever_Anjos]

I´m guessing you have MODIFIED_DATE in your table, right?
Remove it from your table just to check.
It would be easier if you upload a qvw

[Clever_Anjos]

Hello Bikash,
Is it working now?

[#7]

Hey Clever Anjos,

Yes, that'w working now.

Regards,

Bikash

[Clever_Anjos · Accepted solution]

That´s great news.
Please mark the topic as 'answered', so
Best regards