Why do pie charts not display correctly for future dates?

Community Alums · ‎11-23-2018

Hi all,

I may be being a bit dense, so please feel free to point out if I am being.

I'm running a report for "Show me a pie chart for all the future warranty dates for Dell items".

My filter is along the lines of:

Warranty Date After Today
Manufacturer is Dell

In a list view, it pulls the list correctly, in a pie chart view it shows this:

Any ideas?

Community Alums · ‎11-28-2018

I raised a Hi ticket for help with this. It's not an error - apparently Report Ranges aren't designed to work with future dates, this is the full response:

This issue was tracked in a Problem record PRB630400 ==> Bar charts grouped by a date column cannot display records in the future. An enhancement task FTASK30090 was also created but this was not prioritized and hence this problem was closed as this is not a Problem defect with the following comment "Not a defect, simply a consequence of design. Report Ranges were never intended to support future dates." 

I have linked this ticket to the PROBLEM record. 

What I can do is associate this ticket with the problem ticket. It may not get fixed but it will put some weight on the issue such that an enhancement may be approved.

Ah well 😞

View solution in original post

Alberto Consonn · ‎11-23-2018

Hi Mike,

looking at your data, it seems there is no any records for "Manufacturer is Dell" in the future dates, that's why the Pie Chart is not shown.

If there is no record, the Pie Chart wouldn't be able to be shown. Please check your filter conditions and try again.

Please, remember to mark Correct or Helpful if you find my response useful.

Cheers
Alberto

Community Alums · ‎11-23-2018

There's data - in the list view it's fine. I didn't put the screenshot up as it had some data in it, which I've tried to blur out here:

The the same filter, just a different report type

Ahmmed Ali · ‎11-23-2018

Which field you have set as group by ? what type of field it is?

If I could help you with your Query then, please hit the Thumb Icon and mark my answer as Correct!!

Thank you,
Ali

Community Alums · ‎11-23-2018

On both I tried to group by the same field "warranty expiration". It looks like it's trying to do it in the pie chart, as the grouping of "same day, 1-2 days, etc" is appearing at the bottom, just with no data.