How do I group by types of devices in eazybi?

Yousif Al Rawahi March 19, 2024

How do I group by types of devices in eazybi?

For example, I want to group all ZK Access Control as one, and I want to view total number of ZK Access Control?

FYI: These data are taken from jira assets. 

 

Objects
created
Object
Other
Devices 1
Type
Other Devices 1
100 
3F-VENDER
1ZK Access Control
4F- CCTV-515
1ZK Access Control
4F- MNG-511
1ZK Access Control
4F- Server-516
1ZK Access Control
4F- tech-513
1ZK Access Control
4F- tech-526
1ZK Access Control
4F-Archive-524
1ZK Access Control
4F-MNG-514
1ZK Access Control
4F-MNG-517
1ZK Access Control
4F-MNG-530
1ZK Access Control
4F-MNG-531
1ZK Access Control
4F-NOC-512
1ZK Access Control
4F-OUT
1ZK Access Control
4F-VFO-527
1ZK Access Control
4F-WAR-534
1ZK Access Control
4F-tech-528
1ZK Access Control
4F-tech-529
1ZK Access Control
4F-tech-533
1ZK Access Control
5F- Care-518
1ZK Access Control
5F- Care-519
1ZK Access Control
5F- Care-520
1ZK Access Control
5F- Care-521
1ZK Access Control
5F- Main-522
1ZK Access Control
5F- server-523
1ZK Access Control
5F- server-525
1ZK Access Control
5F-IT store-522
1ZK Access Control
5F-OUT
1ZK Access Control
AP-01
1Cisco Meraki AP
AP-02
1Cisco Meraki AP
AP-03
1Cisco Meraki AP
AP-04
1Cisco Meraki AP
AP-05
1Cisco Meraki AP
AP-06
1Cisco Meraki AP
AP-07
1Cisco Meraki AP
AP01
1Cisco Catalyst AP
AP02
1Cisco Catalyst AP
AP03
1Cisco Catalyst AP
AP04
1Cisco Catalyst AP
AP05
1Cisco Catalyst AP
AP06
1Cisco Catalyst AP
AP07
1Cisco Catalyst AP
AP08
1Cisco Catalyst AP
AP09
1Cisco Catalyst AP
AP10
1Cisco Catalyst AP
AP11
1Cisco Catalyst AP
AP12
1Cisco Catalyst AP
AP13
1Cisco Catalyst AP
AP14
1Cisco Catalyst AP
AP15
1Cisco Catalyst AP
AP41
1Cisco Catalyst AP
AP55
1Cisco Catalyst AP
APA00F.3713.2478
1Cisco Catalyst AP
APA00F.3713.4698
1Cisco Catalyst AP
APA00F.3713.5088
1Cisco Catalyst AP
APA00F.3713.527C
1Cisco Catalyst AP
APA00F.3713.6824
1Cisco Catalyst AP
APA00F.3713.69BC
1Cisco Catalyst AP
APA00F.3713.7478
1Cisco Catalyst AP
APA00F.3713.7608
1Cisco Catalyst AP
APA00F.3713.7788
1Cisco Catalyst AP
APA00F.3713.79A4
1Cisco Catalyst AP
APA00F.3713.7A5C
1Cisco Catalyst AP
APA00F.3713.A9E0
1Cisco Catalyst AP
APA00F.3713.E9F8
1Cisco Catalyst AP
APA00F.3714.1754
1Cisco Catalyst AP
APA00F.3714.180C
1Cisco Catalyst AP
APA00F.3714.182C
1Cisco Catalyst AP
APA00F.3714.1870
1Cisco Catalyst AP
APA00F.3714.1C84
1Cisco Catalyst AP
APA00F.3714.1EC8
1Cisco Catalyst AP
Ap16
1Cisco Catalyst AP
HVC 1
1Video Conference Devices
HVC 10
1Video Conference Devices
HVC 11
1Video Conference Devices
HVC 12
1Video Conference Devices
HVC 2
1Video Conference Devices
HVC 3
1Video Conference Devices
HVC 4
1Video Conference Devices
HVC 5
1Video Conference Devices
HVC 6
1Video Conference Devices
HVC 7
1Video Conference Devices
HVC 8
1Video Conference Devices
HVC 9
1Video Conference Devices
SAM. TV 1
1TV
SAM. TV 10
1TV
SAM. TV 11
1TV
SAM. TV 12
1TV
SAM. TV 13
1TV
SAM. TV 14
1TV
SAM. TV 15
1TV
SAM. TV 16
1TV
SAM. TV 2
1TV
SAM. TV 3
1TV
SAM. TV 4
1TV
SAM. TV 5
1TV
SAM. TV 6
1TV
SAM. TV 7
1TV
SAM. TV 8
1TV
SAM. TV 9
1TV

1 answer

1 accepted

0 votes
Answer accepted
Roberts Čāčus
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 19, 2024

Hi @Yousif Al Rawahi

The "Other Devices 1 Type" is an object attribute. Please select the attribute for import in the eazyBI import options under the specific object type - https://docs.eazybi.com/eazybi/data-import/data-from-jira/assets#Assets-Importoptions.

After importing the attribute as a dimension, you can select it in the report rows, and the measure "Objects created" will group the number of objects by the attribute value.

Best,
Roberts // support@eazybi.com

Yousif Al Rawahi March 25, 2024

Very helpful!

Thanks

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
TAGS
AUG Leaders

Atlassian Community Events