Data exist, but not displayed in the Graph
Dear Sir/Madam,
When the report displays all data the last month in the graph is missing, but when a line is being selected all months are being displayed in the graph.
Why is this happening and how is it possible to fix it?
Thank you in advance for your support.
Yours sincerely,
Vassilis Floros
0
Comments
Hi Vassilis,
Does look strange, indeed.
Not sure this is the case here, but you could try 'Data Limit' setting in chart options. Setting it to '0' should show all data.
Let me know if this was the correct fix.
BR / Ole
Dear Ole,
Yes, your suggestion corrected the issue, but now the report is very slow for the every day user.
Due to the fact that the report reads more than 2M cells of data, is there any other way to fix it?
Thank you in advance for your support.
Best regards,
Vassilis
Hi Vassilis,
You will then need to limit the amount of data that the TARGIT object reads.
I guess you need to read the 2M cells of data because you afterwards make calculations based on these - and then the calculated values are the ones you present in the graph ... ?
Only solution is to move these calculations to the Data Warehouse level, if possible. Then you will be able to pull only the calculated values from the Data Warehouse, which should be much less than the 2M cells.
BR / Ole
Please sign in to leave a comment.