Skip to Content
0

Empty dimension values on table?

Jul 13, 2017 at 04:47 PM

68

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Koen Hesters Jul 14, 2017 at 12:34 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Kuldeep Ghosh Jul 14, 2017 at 01:20 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded