This content has been marked as final. Show 2 replies
I have a very easy data model and I like to calculate the LINEST_M value (Trend line)
I have a field that represents a Year_Quarter = [%KwartaalJaar], a category = [ProjectPrestatie_Onderzoeksveld] and a value field = [PP_Cijfer]
I like to calculate the LINEST_M for the Categories over the Quarters, I use the following expression:
LINEST_M( AGGR(AVG(PP_Cijfer), %KwartaalJaar),%KwartaalJaar)
But I don't get a value, what am I doing wrong??
See attached document
Thanks in advance!