Custom or Calculated Fields in BI Dashboard

[rinks]

I created a dashboard in the Sites BI Dashboards to show free space remaining on Win 10 laptops and their EOL information. I don't want the Free Space column to be in bytes as the people who are going to be using this dashboard will have to do division and would rather have a solid "X GB of space remaining" field to easily identify which laptops would have to get some cleanup so they can be upgraded to Win 11.

I made a report in Classic that does this with simple SQL, however we want to start utilizing the BI Dashboards and I was not able to MongoDB a comparative report and I don't see an option in the BI Dashboard widgets to add custom or calculated/expression fields.

[twmackenzie · Accepted solution]

Hi @rinks,

This caught my attention so I started playing and I think I figured it out (albeit not exactly in the way you're asking for it e.g calculated fields). I created a clip for you here https://lansweeper.zoom.us/clips/share/fH29OhmxSDWDdzJdny-6pg 

I'll let one of my more learned friends respond regarding the calculated field point you made!

Thanks,
Thomas

[rinks]

This seems to have worked for what I needed in the BI dashboard! Not sure what "SI" refers to, but it at least reduced the billions of bytes into GB properly. Thank you!