The "System - ARI Extensions" is not installed on my computer.. I'm using j! 1.5.24. I already solved this issue.. I uninstalled 1st the ARI DATA TABLE and I Installed it again.. after that it's work fine now.. I work in localhost 1st that's why I can't provide to you to access in my j! backend.. thank you admin...
I have form again and have field with
| Code: |
<td>Married</td>
<td><select name="married">
<option value="Yes">Yes</option>
<option value="No">No</option>
</select> </td>
</tr>
<td>Pregnant</td>
<td><select name="pregnant">
<option value="Yes">Yes</option>
<option value="No">No</option>
</select> </td>
</tr>
<td>Active</td>
<td><select name="active">
<option value="Yes">Yes</option>
<option value="No">No</option>
</select> </td>
</tr>
|
I want to query one of the option in every column and view this with "ARI Gchart" and type "Column Chart"
Here's the query is used.. and all column give a same count in output.. what i need to add? or change? thanks..
| Code: |
SELECT
pregnant,
gender,
status,
COUNT(pregnant),
COUNT(married),
COUNT(active)
FROM information
|
It is possible to pull only on records is "Yes" only in every column? Let's say on my database record is have 6 pregnant and 4 married and 10 active..
The result is Pregnant=6 Married=4 and active=10..
this is possible in Column Chart? thank you..
