Static X axis

[#1]

Hi all

I am looking at creating a static x axis that does not change even when there is no data in that field

I am wanting to display the number of Missed Tackles by Phase on a bar chart (Total 15 Phases)

However, when there are no Missed Tackles in a specific phase, it does get displayed on the x axis. I need Phases 1-15 to be displayed at all times

The dataset, however, does not display that there was no Missed Tackles in the phase (See Below)

Tackles Missed, PhaseNo

2, 1st Phase

1, 2nd Phase

3, 4th Phase

1, 5th Phase

2, 8th Phase

1, 11th Phase

2, 12th Phase

1, 15h Phase

Thanks

[Gysbert_Wassenaar · Accepted solution]

First you need to create the missing phases themselves. Something like this will do that:

Phases:

LOAD * WHERE not match(PhaseNo,'1th Phase','2th Phase');

LOAD RecNo() & 'th Phase' as PhaseNo

AutoGenerate(15)

  ;

Data:

LOAD * INLINE [

Tackles Missed, PhaseNo

2, 1st Phase

1, 2nd Phase

3, 4th Phase

1, 5th Phase

2, 8th Phase

1, 11th Phase

2, 12th Phase

1, 15th Phase

];

Then in the bar chart go to the Presentation tab of the properties window and uncheck the option Suppress Zero-Values and enable the option Zero on Bars.

[#3]

Thank you

Worked perfectly

I tried to apply this principle to another equation but could not get it right

Its is the same principle except with different data

(All fields include the following)

I need the data to be displayed on the x axis at all times

Nearside - Wide

Nearside - Midfield

Nearside - D3

Nearside - D2

Nearside - D1

RUCK

D1

D2

D3

Midfield

Wide

Tackles Missed, TackleMissedZone

2, D1

1, Wide

3, Nearside - D1

1, Nearside - D2

2, Midfield

1, Wide

2, D3

1, Wide

[Gysbert_Wassenaar]

In this case try an outer join:

Data:

LOAD * INLINE [

Tackles Missed, TackleMissedZone

2, D1

1, Wide

3, Nearside - D1

1, Nearside - D2

2, Midfield

1, Wide

2, D3

1, Wide

];

OUTER JOIN (Data)

LOAD * INLINE [

TackleMissedZone

Nearside - Wide

Nearside - Midfield

Nearside - D3

Nearside - D2

Nearside - D1

RUCK

D1

D2

D3

Midfield

Wide

];