Changing X-axis

[Former Member]

Hi All,

I would like to change the X-axis , in similar to the query that we are using.

Our query in BI has the Gross Turnover for each particular month.

So how do i select X-axis as the month, ranging from 1- 12 and hence in the graph that i use I get the Grossturnover (on the Y-axis) for its particular month ( on X-axis) .

Need your valuable inputs.

Thnx,

NR

[Former Member]

With the BI Integration Wizard, I was able to get the required fields on the x-axis.

Thnks,

NR

[Former Member]

Hi NR,

I'm not sure as for how your query works, but this issue can be usually solved by creating a calculated filed which holds the data you want and using it as an X-axis.

This can be done by adding a calculated field to the output port or be adding a transparent table with a virtual field.

Regards,

Shay

[Former Member]

Hi Shay,

Thnx for the reply, It would be of great help if u can send me a link which explains the process u told me about .

Thnks,

NR