I found that when my barchart has 2 dimensions, the layout shows wrong and I don't know why.
You can see my example data and the barchart, there are some strange space in the barchart.
And I want to get the top 3 per month, I can done the function, but the layout is strange.
Do you know why and any method to solve that?
Another solution could be like, create composite dimension of Month & Company. Use color with Fieldindex function to give color to each company. And use straight table as customized legend.
I don't think so whether we can suspect those null value when we have 2 dimensions? the moment you are talking is and DV is good. But, one free idea - How about Subtype (Stacked) rather Grouped.
Actually I tried the Stacked, it's fine. but I want grouped...because I want to show the comparison among these values.
so...any ideas? I have suppress the null value in dimension, but it's useless.
And i refer this !!! If comparison then Grouped may good rather Stacked
These gaps are due to Company vales are missing from some of the months, for eg. In month 5 you have 5 Company while in month 6 You have just 2. So that Space is there due to missing Company value
thanks for reply, but even I tried the check the suppress missing in presentation tab, it doesn't work, I think it's like a bug, because it's really stupid if the chart keep the space even I don't have the value.
So do you have any ideas to solve or replace that?