How to get unique or distinct records in a report.

vishnumaaya
Tera Contributor

Hi,

 

I am doing drill down report.
Like 1st report is single score report where sum of outage hours is shown and the second report is column type report where sum of outage hours by quarter by business unit is shown and so on.

But it's showing duplicate data. Any idea how can I avoid this please?

Like I have created a database view. Combing few tables and creating report on that.

There are 1585 unique outage records but it's showing 130000 some records.

 

It's not duplicate I am assuming as many tables are combined. One Outage records is showing n number of times.

 

Is the attached database view where clause correct?

 

Thanks,

Vaish

 

0 REPLIES 0