Stop accumulation ahead

Anonymous — Sat, 16 Nov 2024 21:52:59 GMT

Hi, I've been struggling for a while on this script. I have a calendar (Jan to Dec) as my X axis & value as Y axis.

I have data for only a few months, Jan to Mar, however, the data accumulates all the way to the next month (April) even with background colors applied. It's always essentially showcasing data as the month in advance.

See below expression.

=num(SUM({<[New] = {'No'}, [Type] = {'Titan'}>}[Value]))

and background color applied.

if(num(sum({<[Type] = {'Titan'},[New] = {'No'}>}[Value])),rgb(128,0,255),white())
There is only data for 3 months. The background color restricts it, but only up until April (Month ahead, even though there is no data for that month !). Please advise.

Re: Stop accumulation ahead

OmarBenSalem — Thu, 15 Nov 2018 14:14:05 GMT

Can you please attach an image of what u have so that the explanation/expectation would be easier to understand?

Re: Stop accumulation ahead

Anonymous — Wed, 21 Nov 2018 16:08:18 GMT

the example attached. I have data from September to November. No data for November whatsoever.

topic Stop accumulation ahead in App Development

Stop accumulation ahead

Re: Stop accumulation ahead

Re: Stop accumulation ahead