Conditional Dimension

[#1]

Hello,

I am working on building the following chart.

Everything is fine with this chart except that all the dates that don't have any data are showing as 0. I would like this graph to only show data for dates that have data. I update this chart on a Period basis, so there is no need to have all these excess dates that don't yet have data.

Current Dimensions:

Current Measure:

Can anyone provide any insight on how I might do this?

Thanks!

Randall

[swuehl]

Try disabling the option 'show NULL values' (or similar wording) on you chart properties - add ons - data handling.

[#3]

Thanks swuehl. That worked for that particular chart. But I actually have another chart that un-checking that option didn't work for. Any ideas for this one?