CMDBuild Forum

dashboard of site values

Old Versions
#1

Hi, really new to cmdbuild , managed to get it working and created some simple Super Class and Sub Class for our fixed assets (hardware)

 

One of my attributes is an asset value,(type decimal)

What I would like to do is to create a simple dashboard or view that somehow showed the SUM of all the asset values , ideally by another attribute value Site Name (thats a reference attribute via a domain to another class list called site)


I cant seem to work out how to do the Sum part is that possible?  dont really mind if its just sum of all assets initially , and we dont worry about the site attribute

Thanks

John

 

 

#2

You can create a postgres function that calculates for example the sum of the values of assets by category or by state or by location, and then configure a dashboard with a pie chart that shows the results (Administrator Manual page 49).
CMDBuild Team