To create a Data Tables you need SQL Knowledge’s
Data Table or GridView is the easiest Dashboard item you can create. Is a simple SQL Select command. Columns names are the field name that you choose or you can rename using “as”.
You can create 2 types of Data Tables.
Data Tables with Link for record – to link to record you need to include ID in your select query and select Entity dropdown list in Item edit.
Data Table with out Link to record – You don´t need to include ID column in your select.