Empty bar in bar chart and cross bar

Hi,

I have to display like a top-N reports in a bar chart as well as in a cross tab.
If the number of rows returned is less than N, I want to display any empty bar (0 value) in the bar chart and empty column in the cross bar (with empty labels, of course).

Is there anyway to achieve this?

I think I can add the empty values in the bar chart via scripting (in afterDataSetFilled() )
but I am not sure how can I achieve this in crossbar.
I'm using 2.2.1 and scripting is not provided for cross bar.

I don't know whether this can be done from the query or scripting at the dataset level.

Find more posts tagged with

Comments

mwilliams

For the crosstab, you may have to create dummy rows in your dataSet to add extra columns that are blank in your crosstab. Then you could just filter your crosstab to not show these values if you have your N columns. Haven't tried it, but it should work.