Question

1
Replies
187
Views
Close popover
Arun kumar (Arunk138)
HCL Technologies

HCL Technologies
MY
Arunk138 Member since 2013 13 posts
HCL Technologies
Posted: August 16, 2017
Last activity: August 16, 2017
Closed

Report Definition_(Display value across column option) Count with zero

Hi,

A Report definition is designed to display the list of SLA deadline cases for next 7 days. It's achieved by using Display value across column option. The output of the report is displaying the no of deadline cases for next 7 days fine. The issue is if no deadline cases available for anyone of the next 7 days the column for that date is not displaying but expecting to be display with the count as 0.

Current behaviour (Report output):

Workbasket ------9/16/2017-------9/17/2017 ------ 9/19/2017

A ----------------------5 -------------------2 --------------------4

B ----------------------1-------------------- 5 ------------------- 1

Expecting Behavior:

Workbasket -------- 9/16/2017 ---------- 9/17/2017 ----------- 9/18/2017 ---------- 9/19/2017

A ------------------------5 ------------------------2--------------------------0------------------------4

B------------------------1--------------------------4--------------------------0------------------------ 1

(its eliminating the space after save the query so added - between every column to show like report, pls dont confuse)

Reporting
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.