Hi again Dalton

I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.

Calculation functions can only be used on integer and float type columns.

If you need to place this above the table, on front-end, my advice is to create a separate SQL query based table, with a query similar to this:

SELECT  levelStatus,
        COUNT(levelStatus)
FROM yourTable
GROUP BY levelStatus

That way, you will have two columns in that new table:

Level Status | COUNT(levelStatus)
Low          | 2
Normal       | 13
Critical     | 9

Then, you can count the SUM for that column, but it would show the total of all values from a column - in the above case 24, which is not what you want to achieve.

To achieve having a SUM for every value, you can try this query:

SELECT 
( SELECT
        COUNT(levelStatus)
        FROM yourTable
        WHERE state = 'Low'
) AS Low,
( SELECT
        COUNT(levelStatus)
        FROM yourTable
        WHERE state = 'Normal'
) AS Normal,
( SELECT
        COUNT(levelStatus)
        FROM yourTable
        WHERE state = 'Critical'
) AS Critical,
FROM yourTable
GROUP BY Low

And the table will look like this:

Low | Normal | Critical
2   | 13     | 9

Then you can calculate the for each of these columns, and use the SUM shortcode to display it on the page where the original table is:

Please note, though, that this sort of query will result in the SUM not to return the correct result, so you will need to disable server-side processing for this table.

I hope that helps.

Hi Dalton

I'm sorry, but JSON tables are not being stored in the database, so you can't pull them using SQL queries, unfortunately.

The tables are only linked to the JSON tables, so all the data is being pulled from that external file, and therefore can't be referenced in the query - meaning you couldn't create a table from the external JSON file.

You're welcome Dalton.

Sorry I couldn't provide a more useful response.

If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.