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,