Skip to main content
Solved

How to create software overview per department in Analytics

  • December 17, 2024
  • 3 replies
  • 26 views
T
Contributor
Forum|alt.badge.img

Hi everyone,

 

I am trying to create an overview of software that is used per department. I am struggling with it for a while for what I thought it would be an easy overview.

So what I did:

  • I created a widget from scratch using a chart
  • I use the Metric “Users Count (Sum)
  • I group by Name (which is the name of the software)

The only thing I need to add is the department of the user. Whatever I try, it does not give me the correct results.

One difficulty: Some software is linked to ‘Used by’ (the user) and some is linked to ‘Installed’ (the machine). Of course it would be great to see it in one overview, but I can live with two different widgets (one for user, one for machine).

 

Does anyone have an idea how to solve it?

 

Thanks, Tom

Best answer by Amrit Mishra

​@TomPeeters Please see if the following steps can help you get the desired report.

  1. Select metric as ‘Users’ from ‘Users’ module.
  2. Group by ‘Software Used’ ‘Name’ and ‘Department’ ‘Name’.

Screenshot of the configuration attached below.

 

View original
Did this topic help you find an answer to your question?

3 replies

Amrit Mishra
Community Manager
Forum|alt.badge.img+5
  • Amrit MishraCommunity Manager
  • Community Manager
  • 130 replies
  • Answer
  • December 19, 2024

​@TomPeeters Please see if the following steps can help you get the desired report.

  1. Select metric as ‘Users’ from ‘Users’ module.
  2. Group by ‘Software Used’ ‘Name’ and ‘Department’ ‘Name’.

Screenshot of the configuration attached below.

 

T
Contributor
Forum|alt.badge.img
  • TomPeeters
  • Author
  • Contributor
  • 3 replies
  • December 19, 2024

Hi ​@Amrit Mishra,

 

It seems this does the trick, thanks a lot!

Is it correct that this displays all software that is logged under Users?
Do you perhaps also know how to create the same overview but for software installations?
In line with your instruction I thought I might use the metric ‘Asset’, but there I have no option to group by Department.

 

Kind regards,

Tom

 

T
Contributor
Forum|alt.badge.img
  • TomPeeters
  • Author
  • Contributor
  • 3 replies
  • December 19, 2024

Hi ​@Amrit Mishra ,

 

I was able to create the report on software installations. In line with your instruction I thought I might use the metric ‘Asset’, but there I have no option to group by Department. I had an interactive filter placed on the report. After removing that filter, I had all the group by options i needed.

 

Thanks for your help!

 

Tom

Amrit Mishra
1 person likes this
  • Amrit Mishra
    Amrit Mishra

Reply


Most helpful members this week

Terms of UsePrivacy Notice