ARI Soft - Simple Bar Chart

Home

News

Forum

About Us

Demos

Products

F.A.Q.

Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin

e-mail: info@ari-soft.com

Shopping Cart

You currently have 0 items in your cart.

Show Cart

Recent Events

23/11/2024 Black Friday 2024

BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

more...
31/12/2023 New Year SALE

We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

more...

2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft.

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Smart Content

Simple Bar Chart

(1 viewing) (1) Guest

Page: 1

TOPIC: Simple Bar Chart

Forum Tools

#46808

Simple Bar Chart 11 Years, 10 Months ago	Karma: 0
Hi all, how would I go about doing a simple bar chart with the arijdatavisualizer (I'm using an SQL query as a base but that shouldn't matter here)? All the examples I find have more than one dimension (i.e. multiple columns). cheers Fred

frederik

Last Edit: 2013/12/17 00:18 By frederik.Reason: Added bar chart

The administrator has disabled public write access.

#46812

Re:Simple Bar Chart 11 Years, 10 Months ago Karma: 765

Hello,

The following plugin code:

Code:



{arijdatavisualizer type="bar" hideTable="true" width="500" height="400"}

	<table>

		<thead>

			<tr>

				<td></td>

				<th>Count</th>

			</tr>

		</thead>

  		<tbody>

			<tr>

				<th>2009</th>

				<td>2</td>

			</tr>

			<tr>

				<th>2010</th>

				<td>4</td>

			</tr>

			<tr>

				<th>2011</th>

				<td>5</td>

			</tr>

			<tr>

				<th>2012</th>

				<td>6</td>

			</tr>

  		</tbody>

	</table>

{/arijdatavisualizer}

will be rendered as:

Regards,
ARI Soft

admin

The administrator has disabled public write access.

#46813

Re:Simple Bar Chart 11 Years, 10 Months ago Karma: 0

Thanks for the quick response. I got my sql table to your format now (just in case anyone finds this useful).

Code:

{arijdatavisualizer type="bar" hideTable="true" width="400" height="400"}

{arisqltable}

    {arisqltablecolumns}

      {arisqltablecolumn id="Jahr" alias="Jahr" headCellTag="td" cellTag="th"}

      {arisqltablecolumn id="Anzahl" alias="Anzahl"}

    {/arisqltablecolumns}

    {arisqltablequery}

	SELECT YEAR(birthdate) as Jahr, count(*) as Anzahl FROM joomla_contentbuilder_list_records statelinks, joomla_contentbuilder_list_states states, joomla_zp_waitinglist wlist 

	WHERE statelinks.state_id = states.id AND states.title = 'Aufgenommen' AND wlist.id = statelinks.record_id GROUP BY YEAR(birthdate);

    {/arisqltablequery}

{/arisqltable}

{/arijdatavisualizer}

However, the style is a bit messed up (probably because my theme resets a lot of basic css). Is there any recommendation on how to proceed? Otherwise I'll have to go through each property to see what is messing up my graph.

frederik

Last Edit: 2013/12/17 10:24 By frederik.

The administrator has disabled public write access.

#46814

Re:Simple Bar Chart 11 Years, 10 Months ago Karma: 765

Try to wrap plugin code with the following HTML code:

Code:



<div style="margin: 20px;">

... plugin code goes here ...

</div>

Regards,
ARI Soft

admin

The administrator has disabled public write access.

Page: 1

Useful Links