How to add CALCULATED ITEMS in LINE GRAPH

#Mayur

Hi ,

I have created one report. In that I have added Calculated Items as per requirement.

Now I want to create the Line Graph on the same report using those 2 calculated Items.

But the issue is that these Calculated Items. I am unable to use them in the Line graph.

Any Suggestions?

Thank You.

cesar.advincula.o

Did you try to use a new column in answers with the calculation that you need and show it in the Line Graph?

Kind Regards,

#Mayur

Hi

Earlier I tried with the Column level (Calculated Measures) filter but filter was not working there so I have created the Calculated Items in the report that is meeting to the requirement.

cesar.advincula.o

Could you use FILTER() function?

Kind Regards,

#Mayur

Tried with that too but it's not working.

Carina Mendes

Hi,

You can send us an picure of your report?

I'll like understend better you and help you.

Regards,

Carina Mendes.

#Mayur

Hi ,

This is the my requirement,

For the "sum of % not usable" and "sum of % rejected" created through the Calculated Items.

But when I am trying to create the Graph on the same it is not working.

Thank You,

Mayur

AkanshAgarwal

Hi,

You can create a pivot table and use the graph functionality from there.

You can then display only the graph or both.

Using this will allow you to add calculated columns.

OBIEE in IL: OBIEE - Sorting Graphs / Charts

Regards,

Akansh Agarwal

jackohug

Is the table view displaying the results correctly?

When you say "I am trying to create the Graph on the same it is not working" what does not working mean?

#Mayur

Hi Akansh

I am already using the Pivot table.

And I just want to create the graph on the same report.

Thank You,

Mayur

#Mayur

Hi Jackohug,

Yes it is showing the correct values.

I mean, I am trying to use the Calculated Items which I have created for the Pivot table in the Graph View.

In the Graph it is not working. It is not showing any calculated Items in the Layout properties of the Graph.

Thank You.

Mayur