How can you show 0 in a report on dates?

Forum|Forum|6 years ago
April 23, 2020
13 replies
250 views

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

rakesh

Lets put your data to work!

Can you summarize the date by day?

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

andreammeldeAuthor

Helper ⭐️⭐️

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

Andrea Carroll

rakesh

Lets put your data to work!

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.

sai_ram

Expert ⭐️⭐️

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

andreammeldeAuthor

Helper ⭐️⭐️

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?

Andrea Carroll

jlicciardello

Contributor ⭐️⭐️⭐️⭐️

Another vote for this enhancement to reports please.

carolyndibuono

Contributor ⭐️⭐️⭐️⭐️

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

andreammeldeAuthor

Helper ⭐️⭐️

In the new report builder, I am not not able to see 0’s on days either…. I am attempting to create a report that shows how many surveys are sent over a time period. Screenshot shows that days when 0 surveys were sent are just missing