Acknowledged

How can you show 0 in a report on dates?

  • 23 April 2020
  • 7 replies
  • 114 views

Userlevel 7
Badge +2

We have reports created to  show the due date of specific CTA tasks grouped by week. However if there are no due dates for that particular week, the graphs skips the date. We want to be able to show 0 for these dates rather than have it skipped. Is it possible to require this on graph setup?

 

I tried with both line and bar graphs, and both skip the 0 week

 


7 replies

Userlevel 7

Can you summarize the date by day? 

This will show all the dates even when the data itself is 0. 

 

 

Userlevel 7
Badge +2

The team is looking for a week by view. Why does show if you group by day and not by week, month, etc? Seems like you would want this to show 0 regardless of the grouping

Userlevel 7

Hi @andreammelde 

We only have the time series behavior to show empty data for days. The challenge here is primarily around the bounds - but its a problem that we want to solve. We are introducing more options to show 0’s and nulls regardless of the grouping as long as the date field is present in the Redesign of reporting.

Userlevel 7
Badge +2

@andreammelde did you get a chance to view our comments?

Userlevel 7
Badge +2

for now - this won’t solve bc the users need to see it by week not day. Is there a plan as to when the added options will be available?

Userlevel 5
Badge

Another vote for this enhancement to reports please.

Userlevel 3

+1 for this. This is becoming an increasingly frequent issue for Propeller.

Reply