Any ideas on how I can produce this chart?

[russiver]

I wonder if anyone could advise on how I may be able to achieve the following. I have a table that contains user names plus two fields – ‘primary_channel_no’ - a whole number between 55 & 90 and ‘secondary_channel_no’ - again a whole number between 55 & 90. What I would like to be able to do is firstly merge these two fields and then produce a distribution (vertical bar chart) – ‘x’ axis scale all numbers 55 to 90 and ‘y’ axis frequency.

So far I have managed to merge the two fields using a union query and with a count expression have managed to count the frequency of each number. When I then produce the chart it only displays numbers who’s count is greater than zero. However, I’d really like to show all numbers on the ‘x axis’ in the 55 & 90 range even if their count is zero – this is the key objective of the chart to show users which channels are clear.

Any ideas greatly appreciated.

Russell Skinner

 

[ColinEssex]

Try the NZ function. (Null to Zero)

Col

 

[russiver]

Thanks for the reply Colin. I understand the NZ function but not sure if it will help as the result of my union query only includes channels in use. So if no one has picked say channel #60 it will not appear in the query and hence on the chart. Either I need to find a way of customising the 'x' axis to show all numbers form 55 to 90, or maybe rethink the way of compiling the data.

Russell