X Axis doesn't appear [SOLVED]

This message was edited 1 time. Last update was at 12/09/2012 16:34:15

Hi,

I am trying make a highchart but my <X_Axis> doesn't appear with the values from my dataset. I put the alias 'month' in this axis but when I execute the document only shows the value '0' and when I run the preview of dataset show me the result of the query that I want to put in the chart.

Anyone can help me?

Please post the template.

Thanks

The template is:

The query:

SELECT COUNT(agend_num_processo) AS total, EXTRACT(MONTH FROM agend_data_prova) AS mes
FROM UEGDe_agendamento_pd
WHERE
agend_data_prova BETWEEN '$P{dt1}' AND '$P{dt2}' AND
agend_info_presenca = 2 GROUP BY MONTH(agend_data_prova)

The result of my query is:

Please try this:

<SERIES_LIST>
SERIES name='Aprovados' alias='mes,total' />
</SERIES_LIST>

thanks

Not yet.

Any could help me construct a chart-highchart with this datas:

I didn't understand how put the data on the chart... (noob doubt).

I made this template:

To execute the document, don't appear any data on the chart.

I want a simple chart like this:

Anyone?

It seems issue because of special character(') in <TITLE text="Approved's Total"/>

Here is the updated template

<HIGHCHART>
<CHART defaultSeriesType="column"/>
<TITLE text="Approved Total"/>
<LEGEND />
<SUBTITLE text="Approved "/>
<X_AXIS tickWidth="4" alias='month'>
<TITLE text='Month' />
</X_AXIS>
<Y_AXIS >
<TITLE text="Total" align='high'/>
</Y_AXIS>
<PLOT_OPTIONS>
<COLUMN>
<DATA_LABELS/>
</COLUMN>
</PLOT_OPTIONS>
<DRILL>
<PARAM_LIST/>
</DRILL>
<SERIES_LIST>
<SERIES name="Approved by month" alias='month,total'/>
</SERIES_LIST>
</HIGHCHART>

It is working fine in my machine

Thanks

Hi Hemgoyal,

Thank you so much for your answer. My suspicion is almost a certainty. Can you help me more one time?

I tried with your template but I didn't get the chart yet. I forgot to say that I'm trying make this document with parameters. I will try explain:
I want a chart that show the quantity of approved in a proof according a period of the year that my user to choose.
Eg:

My user has to choose a initial date and a final date (any date of the year) and then the chart shows the result of approved.

I have the dataset:

The result of dataset is:

The template you know;

To create the document I added a DOCUMENT ANALYTICAL DRIVER called InitialDate and FinalDate with the Driver AD_Date.

When a execute the document, appear the input to the user choose a initial date and a final date and when I click on run document, doesn't show me the result from my dataset in the chart. So I think that the error is the Parameter.

Are there any other configuration that I have to do?
How the dataset receives the dates like parameters?

Thank you!

Hi Marcia,

Few suggestions which might help you:

1. agend_data_prova is date format and parameter is in string format.
So in the SQL query, you need to convert date in string format to DB date format.

2. Please check url parameter in AD associated with the Chart.
Url name should be dt1 and dt2

Thanks

Good suggestions!

I'm looking for an example about the suggestion nº 1. Soon I will be showing the results for you.

I'm so excited!

This message was edited 2 times. Last update was at 12/09/2012 15:46:47

Yes!!!!!!!!!!!!!!!

Thank you so much!!!!!! Now I understand how to do charts!

I'm crying now!!! I'm so happy!

Thank you!

My dataset now is:

The result was:

upload picture

Now, I have to adjust the values of Y axis. Why appear a letter K?