How can i hide object in line chart?

[Former Member]

In Webi XI R2, i am preparing a line chart for which on x-axis i have two objects like "month name" and "month ID". The purpose of "month ID" is to sort the month name. So sorting is applied on "month ID" column. Now how can i hide this "month ID" column, but still sorting is applied so that month name is displayed in correct order.

secondly, on the x-axis values are displaying like "AUG/00987","SEP/00988". i.e Month name/month ID. How can i make the line chart to display only month name but still sorting needs to be applied.

Please advise.

[Former Member]

Hi Raveendra,

The best option is to create a Date variable in the report using the month, for example, if you have an object with YYYYMM, you can use it to generate a variable like: ToDate(<YYYYMM object>+"01";"YYYYMMDD") then you will be able to change the format to Mmm in the graph.

[Former Member]

Hi Raveendra,

You can try to hide the column from the webi report in a TABLE, and might just work with the table, and make them charts.

regards,

Shreyash.

[Former Member]

This is correct, we are planning on having this feature in the future.

[Former Member]

Hello Raveendra,

You cannot hide objects in Webi charts or tables as you can in Deski.

James