Empty dimension values on table?

[Former Member]

Hello I am trying to build a report. that shows the quantity of calls our system gets trough a day. this has to be organized by time interval im using the 30 minutes object.

The problem comes when i want to display the entire interval regardless if there was any call on that time interval, the report doesnt bring those. Following some suggestions of other questions on this site. I built another query bringing only the 30 minutes object

I have enabled the options to display the empty dimensions.

the problem with that is that i know have for some reason offered calls with no time interval here is an example of what im getting

30 MINUTES Offered

2017-07-11 23:00-23:45 18

2017-07-11 23:45-00:00 07

9 <---- these calls should have a date

8 <---- these calls should have a date

would anyone help me ? I don't know how to approach this problem.

[former_member198519]

Can you give us a snippet of the data you are trying to see?

[kohesco]

Hi,

if the query of bringing only the 30 minutes object reproduces bad values. ask DB to clean their tables. If not possible set code at universe level--> if value_check = okay set value else null or something. IF you are not allowed to do changes at universe level, just filter the correct values out in your query

Grtz

Koen