May 30, 2007 at 3:13 pm
I'm supposed to show a graph of how much we've made from a bunch of customers. This lends itself quite well to a bar graph, which is what im using. The problem is that when I look at the graph for a whole year, the number of customers causes half the axis labels to vanish. My attempts to remedy my problem resulted in two things working: smaller label text, and a larger graph. Both of these let me see every label, but at the price of a not-quite-so-good-looking graph. Size 6 pt font isn't great to look at, nor is only 60% of the graph.
My manager suggested to me to try to group the customer's who we've made less than $5000 (or some arbitrary number) from, since the graph is mostly only good to figure out who the big customer's are.
I've been trying to think of how to do this, but just can't figure it out. Anyone have any ideas?
Edit:my other idea was to simply filter out said customers, but the data points are sums, and i can't filter sums
May 30, 2007 at 3:37 pm
Look up GROUP BY and HAVING in the Books OnLine.
GROUP BY Customers
HAVING Sales > 5000
-SQLBill
May 30, 2007 at 3:59 pm
So I think i posted this in the wrong place, I reposted in reporting services, since that seems more applicable. The graph is in a report, and so I'm not exactly in the place to edit my query. If I knew how to delete this thread, I would, so some admin feel free. It would appear I live up to the name of this forum!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply