topic Problem with zeroes when using set analysis in App Development

Problem with zeroes when using set analysis

kruel830 — Thu, 29 Nov 2018 08:19:30 GMT

I have created bar chart with dynamic date limits for Nprinting, but I don't know how to hide zero values. Bar chart shows YTD figures for 2018 and 2017 and therefore chart looks stupid as I have used year as dimension, but I don't know what else dimensions I could use. "Include null values"-selection does nothing for this. Any help?

Re: Problem with zeroes when using set analysis

Anil_Babu_Samineni — Thu, 29 Nov 2018 08:40:11 GMT

Can you please share sample test file to demonstrate the issue?

Re: Problem with zeroes when using set analysis

kruel830 — Thu, 29 Nov 2018 08:53:58 GMT

Unfortunately I can't, but I can tell expressions I have used:

Dimension: Year

Revenue YTD: Sum({<Date = {'>=$(=YearStart((now())))<=$(=MonthEnd(AddMonths(now(),-1)))'}>} [Sales])
Budgeted: Sum({<Date = {'>=$(=YearStart((now())))<=$(=MonthEnd(AddMonths(now(),-1)))'}>} [BudSales])
Oct 2017: Sum({<Date = {'>=$(=YearStart((now()-395)))<=$(=MonthEnd(AddMonths(now(),-13)))'}>} [Sales])

I understand why it displays 2017 and 2018 labels, it is because there is data from 2017 and also from 2018. And some of them are zeroes. e.g. Revenue YTD doesn't have any data from the year 2017. But I want those 3 bars to next to each other, not like those are now.

Re: Problem with zeroes when using set analysis

Anil_Babu_Samineni — Thu, 29 Nov 2018 08:56:11 GMT

Sorry