Need help for showing others row of a bar chart for networkdays

[#1]

Hello,

I have created a bar chart to show the frequency of activities for networkdays. For example, in the following bar chart, there are 786 activities having 1 networkday, 904 activities having 2 networkdays and so on. The dimension I used is (=networkdays(ActDateStart, ActDateEnd) and the expression I used is count(ActDateEnd). I set the graph to only show the largest 35 values and also show others.

The above graph shows the data I am looking for. However, when I click on the "others" bar, the following graph shows up instead of showing the next 35 networkdays values. Moreover, the selection box shows selection for ActDateStart and ActDateEnd.

I am suspecting failure of showing the next 35 values by clicking the "others" bar is because I use an equation (=networkdays(ActDateStart, ActDateEnd) in Dimemsions. Will it make a difference if I create a field for networkdays by editing the script?

Do you know how to fix this? Please advise.

Thank you very much.

[swuehl]

I don't think it will make a difference.

But I wasn't able to reproduce what you are seeing, can you post a small sample app?

In general, when you select in a chart, you are actually selecting dimension values.

Since your dimension is based on a calculation involving two fields, the selection is made in both fields.