Hi
I have problems to show graphical statistics on my Ari Data Table module

I'm taking data from rsforms pro submissions field on MySQL db what i'm trying to obtain is something like images attached

In few words i need a graphical representation of submissions and name of the forms submitted

i have tried in this way

( SELECT COUNT( * )
FROM `ctlmz_rsform_submissions`
WHERE FormId =14
) UNION ( SELECT FormName FROM `ctlmz_rsform_forms` WHERE FormID=14)

but i'm obtaining syntax errors

Could someone help me

Thank you to all of you great module

Hello,

Could you send SQL dump for "ctlmz_rsform_submissions" and "ctlmz_rsform_forms" tables by email so we can investigate the problem?

Regards,
ARI Soft

email sent

Thank you

Set "SQL -> SQL query" parameter to the next value:


SELECT
FormName,
COUNT(S.SubmissionId) AS Count
FROM
`#__rsform_forms` F LEFT JOIN `#__rsform_submissions` S
ON F.FormId = S.FormId
GROUP BY
F.FormId
ORDER BY
F.FormName ASC


Set "SQL -> Revert data" to "Yes", set "Choose table type" to "ARI GChart" and "ARI GChart -> Type" to "Column chart".

Regards,
ARI Soft

Thank you it's working like a charm you are great

last question:

It's possible to build a graphic in authomatic selecting a value from a form ?

example:

i have a table built with ari data with all the fields extracted from a table db

when i select a column can i have showed in a graphical way all the values like in the previous post ?

Sorry, but the module doesn't support this ability.

Regards,
ARI Soft