Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Distinct values in a day for each hour In Webi or Universe


I have the below requirement.

I have a date field with date time format. I will get the one value per hour for 3 of the cities and rest of the cities I will get only one value for entire day.

the 3 cities which get 24 values per day are around 3 distinct values. so I need to show only one row with 3 different columns.

Suppose I run a report from 01/01/2015 to 01/31/2015, the report should looks like the attachment.

So as per the attachment, if i get the 3 distinct values in 24 hrs I need show them in 3 columns, If I get only 2 distinct values in 24 hrs I need show them in 2 columns and 3rd column will be empty. If I have only distinct value in 24 hours I need to show only first column then 2nd and 3rd columns will be empty.

finally I need to show one row for one day.

Please suggest me.

Thanks In advance,


Forum.PNG (4201 B)
Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question