Have anyone has a class that profiles a table? Example, total rows, total nulls, average, max , min for each column on th
I created a table profile dashboard on Power BI, but I wonder if is possible to do it in Iris by creating a class.
HealthShare Clinical Viewer 2022.2.2 Build: 1000 Adhoc: 23127 [HealthShare Modules: Core:24.0 + Clinical Viewer:24.0] - IRIS for UNIX (Red Hat Enterprise Linux 8 for x86-64) 2022.1 (Build 209_0_23127U) Mon Feb 12 2024 18:21:53 EST [Core:24.0|Clinical Viewer:24.0]

Comments
Hi. Of course! If you have data classes, you can enable Analytics for your namespace, create a data cube, and then create various pivot tables in Analyzer. This will allow you to create visualizations.
Take a look at this docs
https://docs.intersystems.com/irisforhealthlatest/csp/docbook/DocBook.UI.Page.cls?KEY=PAGE_bi
And this group of articles covers all the necessary features of analytics.
https://community.intersystems.com/post/basics-creating-dashboards-pivot-tables-and-widgets-iris-bi-platform
https://community.intersystems.com/post/basics-using-architect-efficient-data-management-and-analysis-intersystems-iris-data-platform
https://community.intersystems.com/post/basics-using-analyzer-effective-data-management-and-analysis-intersystems-iris-data-platform
https://community.intersystems.com/post/example-building-analytics-drilldown-static-report-interactive-dashboard
https://community.intersystems.com/post/how-develop-iris-bi-also-change…
And this app. With this package you have more options to visualize your data
https://openexchange.intersystems.com/package/DeepSeeWeb
Keep in mind that this app only works with this API
https://openexchange.intersystems.com/package/MDX2JSON
Hi @Jacinto Busquets !
I think your request is interesting, and I spent a vibecoding evening to introduce a sample that can help with the task.
So I've built a backend on IRIS that goes through persistent classes in a namespace and provides stats on the columns of every class how are they filled. And built a frontend for it. Here is the demo server:
How to have it on your own server:
you should have IPM client installed, and then do:
USER> zpm "install iris-table-stats-frontend"
and
USER>zpm "install esh-iris-table-stats"
and open the UI at /iris-table-stats-ui/index.html endpoint of your IRIS server.
if you want to play with test data there are several dataset apps, like the medical dataset from @Muhammad Waseem or the Health Dataset from @Yuri Marx
Here is a small Loom video on how it works
also empty records and csv export were introduced
