cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
GMFDE
Engaged Sweeper III
I've got a chart report that lists all the browsers by version. What I want is to combine the different versions so that the X axis is simply
1. Internet Explorer 4721
2. Firefox 275
3. Chrome 74
4. Opera 12


As it stands now, the chart has about 35 entries in the X axis due to all the various versions. Below is the code I'm working with.

Any help is appreciated.


Select Top 1000000 tblSoftwareUni.softwareName As Software,
Count(tblSoftwareUni.softwareName) As Count
From tblSoftware
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Where (tblSoftwareUni.SoftwarePublisher Like '%Microsoft%') Or
(tblSoftwareUni.SoftwarePublisher Like '%Mozilla%') Or
(tblSoftwareUni.SoftwarePublisher Like '%Google%')
Group By tblSoftwareUni.softwareName
Having (tblSoftwareUni.softwareName Like '%Windows Internet Explorer%') Or
(tblSoftwareUni.softwareName Like '%Firefox%') Or
(tblSoftwareUni.softwareName Like '%Chrome')
Order By Count Desc
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
You appear to have posted this question at the beginning of December as well, and I responded shortly after. You can find the previous forum thread here.

View solution in original post

4 REPLIES 4
Susan_A
Lansweeper Alumni
I'm not sure whether moving a topic prevents email notifications. You do need to ensure notifications are enabled in your profile as well, as far as I know. Click your username, select Email Notifications and enable one of the options below.
  • Notification for topics you've posted to, watched or marked as favorite
  • Notification for topics or forums you've selectively watched (listed below)
GMFDE
Engaged Sweeper III
If I flag a question "Watch this topic and receive notifications of activity via e-mail?" Should I expect to get an email notification? Perhaps if the post is moved to another section it breaks the notification script? Regardless, I never saw your response.

Thank you for responding to the question. Thank you for moving the post to the appropriate section.
Susan_A
Lansweeper Alumni
You appear to have posted this question at the beginning of December as well, and I responded shortly after. You can find the previous forum thread here.
RCorbeil
Honored Sweeper II
Refer to this thread.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now