Error in creating a trendline - OBIEE 12c

Question

Hello,

I have a problem with TRENDLINE in OBIEE 12c.

I am trying to use a formula like this:

TRENDLINE(100 - ((IFNULL(Sum(DISTINCT "XX"),0) / ("YY"*24.0)) * 100.0), ("TIME"."DAY_DATE"), 'LINEAR','VALUE')

"XX" - type: double

"YY" - type: double

"TIME"."DAY_DATE" - type: date

I get this error:

State: HY000. Code: 42071. [nQSError: 42071] Trendline Y-axis grain can only be the same as or lower than Trendline X-axis grain. (HY000)

What I am doing wrong?

Best Regards

Sumanth V -Oracle · Answer

@User_BCACP - The error message indicates that the Y-axis grain (the data level used for the calculated values) must be at the same or a lower level than the X-axis grain (in this case, "TIME"."DAY_DATE").

* The X-axis is based on "TIME"."DAY_DATE" (which is at a daily grain).
* The Y-axis formula references "XX" and "YY" without explicitly ensuring they are also at the daily level.

Make sure "XX" and "YY" are aggregated at the daily level before being used in the formula.

Hope this helps!