nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

How to add CALCULATED ITEMS in LINE GRAPH

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.

Find more posts tagged with

Accepted answers

All comments

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,

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,

Tried with that too but it's not working.

Hi,

You can send us an picure of your report?

I'll like understend better you and help you.

Regards,

Carina Mendes.

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

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

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?

Hi Akansh

I am already using the Pivot table.

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

Thank You,

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