Remove dimension values if count observations < 100

[#1]

Hello all,

I have a trend analyse in my application. A bookyear is showing average scores.

Customer only wants to see a month if the # of observations > 100.

I succeeded showing an average of 0 if the nbr of observations < 100, but they would like to remove the complete month from the line graph in this case.

I tried to do something with Suppress zero values, but did not succeed yet.

Any suggestions?

Thanks!

Best regards, Patricia

[johnw]

OK, I have a solution working for two dimensions now. It's rather complicated, including an AsOf table to connect a month to the next month, and two charts carefully lined up on top of each other. The conditional color assigned is no longer blue vs. white, but default color vs. argb(0,255,255,255), which is to say transparent white so that the white line never overlays a colored line. It's possible that there is a simpler solution, but at least it seems to be working, and I wasn't able to push the charts out of sync with at least some brief poking at it.

[#3]

Hi John,

Sorry, was on vacation and just read your replies. Thank you so much for this, I really appreciate it!

Very clever! I will show this to my customer this afternoon before implementing.

Still one question. Because I cannot see this published yet, do you know how this will be exported to excel and how it will be printed. Because you used 2 charts. Do you have experience with some other examples with 2 charts on top of each other?

Best regards,

Patricia

[johnw]

There shouldn't be any problem with Excel since both charts contain the same information, just displayed a little differently. So when you export the top chart, you should get what you'd expect. It seems to work. Didn't check all the data, but I do have most months and all products, and there are no zeroes in the Excel, just like there were no zeroes in the chart.

Printing I assume won't work, and will only print the symbols. Yeah, that's what it shows in the print preview, only the symbols, no lines. You'd have to print the sheet instead to see it correctly.