Question Re: Show null values in Bar Chart in Technology Q&A

Show null values in Bar Chart

former_member774219 — Fri, 29 Oct 2021 14:07:26 GMT

Hello All,

I am very new to the SAP Analytics Cloud environment. I want to develop a chart where i have Actuals and Target over Years. Here Till current year we have Actuals(Measure - Sales) but not beyond. So there are null values for actuals for like 2022, 2023 and so on and Target is for 2030 which is a single value. Now bar chart doesn't show the bars for 2022, 2023 and till 2029 as there is no value. If i convert the nulls to zero then 0.0 will be shown with corresponding years as 2022, 2023... which is not acceptable. Null means the year should appear but with no numeric value.

Please suggest how can i achieve this.

Regards

Re: Show null values in Bar Chart

Jay_Gandhi — Fri, 29 Oct 2021 15:19:46 GMT

Hi there,

Have you turned on the unbooked data option in the chart?

This way the years will show up in the axis but no values/bars will be visible on the chart.

Jay

Re: Show null values in Bar Chart

former_member774219 — Mon, 01 Nov 2021 08:28:04 GMT

Hello Jay,

Thank you for your answer and it may solve the issue. But the problem now happening because i have 2 Dimensions and turning on the Unbooked Data option is working for both of them. How can we avoid this situation.

Regards

Re: Show null values in Bar Chart

Jay_Gandhi — Mon, 01 Nov 2021 13:59:53 GMT

Hi there,

You can select the separate dimension and unclick the 'unbooked data' option, then it should only be on the dimension you'd like it turned on for.

Jay

Re: Show null values in Bar Chart

former_member774219 — Tue, 02 Nov 2021 06:07:24 GMT

Thank you for your reply.

Unclicking the 'unbooked data' option for the separate dimension in making the same changes to the other dimension too. That is why i am facing this issue.

Regards

Re: Show null values in Bar Chart

Susanne_H — Tue, 02 Nov 2021 08:44:17 GMT

Dear shashank_vyas62,

'show unbooked' is passed on to the underlying dimensions. Perhaps you can rearrange the order of your dimensions to solve the problem. if only one dimension should 'show unbooked', then this must be the one on the lowest level, see screenshot.

Best regards
Susanne

Re: Show null values in Bar Chart

Jay_Gandhi — Tue, 02 Nov 2021 11:26:08 GMT

Hi there,

You need to re-arrange the dimension order of this is being passed along to the other dimension(s). Make the Time dimension the lowest level dimension and select Unbooked data then.

Jay