Cannot get statistic to work

Queries and Resources
1

Hi, I am new here. I tried to get the total number of records (count(*)) as a value to show as statistic. Whatever I try, I cannot get it to work:

image
image1920×1040 114 KB

Tablename = BSIK_Table
it should show 52 as outcome.

2

Hello @SNMVR6,

Why don't you try {{ table1.data.length }} as a simple solution?

3

Hi, your suggestion did not make a difference, unfortunately.

4

I may not have understood exactly what you meant then. Can you give a little more detail?

5

You shouldn't be using formatDataAsArray() in your query, at least not if you are accessing your data by referencing the table's .data property.
A table's data property is already formatted as an array of objects, which can be queried using the "Query JSON with SQL" resource.
Your query should look like:
SELECT COUNT(*) AS AP_ALL FROM {{BSIK_Table.data}}

image
image1143×816 65.4 KB

However, as @edurmush suggested you can access the same info (The count of items in your list) with {{BSIK_Table.data.length}}.
You could then forego the entire "Query JSON with SQL" query.

1 Like
6

Thanks, it now works. Peculiar as I believe I tried that code before ... anyway, happy that is works. Thanks all.

Michel

1 Like
7