BarChart YAxisFormat

BarChart YAxisFormat

  

Hi All 

I want to show the hidden Year In the Y-Axis

How can i show it ...?!


This is my SQL Statement:

select case_year,

count(distinct case_subtype_code||'-'||case_year||'-'||case_serial_number) the_count

from os_adv_all_cases_01

group by case_year

 order by case_year desc


The Y-Axis is The "case_year" 

The X-Axis Is The "case_subtype_code"


Regards

Hind Ahmed

Hi Hind,


I've done that in the past using the GridLineStep of the YAxisFormat_Init function.


Also, by the Highcharts documentation, it seams you can achieve it using the tickInterval property:

https://api.highcharts.com/highstock/yAxis.tickInterval


Cheers,

Renato



Hind Ahmed wrote:

Hi All 

I want to show the hidden Year In the Y-Axis

How can i show it ...?!


This is my SQL Statement:

select case_year,

count(distinct case_subtype_code||'-'||case_year||'-'||case_serial_number) the_count

from os_adv_all_cases_01

group by case_year

 order by case_year desc


The Y-Axis is The "case_year" 

The X-Axis Is The "case_subtype_code"


Regards

Hind Ahmed



Hi Hind Ahmed,

Take a look at the YAxisFormat_Init function, in particular its the GirdLineStep input parameter.

Hope this helps!

Renato Torres wrote:

Hi Hind,


I've done that in the past using the GridLineStep of the YAxisFormat_Init function.


Also, by the Highcharts documentation, it seams you can achieve it using the tickInterval property:

https://api.highcharts.com/highstock/yAxis.tickInterval


Cheers,

Renato



Hind Ahmed wrote:

Hi All 

I want to show the hidden Year In the Y-Axis

How can i show it ...?!


This is my SQL Statement:

select case_year,

count(distinct case_subtype_code||'-'||case_year||'-'||case_serial_number) the_count

from os_adv_all_cases_01

group by case_year

 order by case_year desc


The Y-Axis is The "case_year" 

The X-Axis Is The "case_subtype_code"


Regards

Hind Ahmed



Hello Renato Torres

But how can i do it, do i have to create a new screen action called YAxisFormat_Init and where i  have to use it ..?!

Regards

Hind Ahmed

Jorge Martins wrote:

Hi Hind Ahmed,

Take a look at the YAxisFormat_Init function, in particular its the GirdLineStep input parameter.

Hope this helps!

Hello Jorge Martins

I found it under the chart, but how can i use it ?!

Regards

Hind Ahmed


Hi Hind Ahmed,

When you place a BarChart (or any kind of Chart) on your screen, you can set the YAxisFormat property of the BarChart instance to be the result of calling the YAxisFormat_Init function.

 You can find the YAxisFormat_Init function in the Expression Editor under User Functions -> Charts