Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
3 years ago
Solved

Trendline needed

I have a simple linechart with MonthName on the x-axis (this is derived from my own custom built calendar going from Apr to Mar as per Financial Year) and a DISTINCTCOUNT Measure of IDs for the Y axi...
Need Help
Show and Tell
  • nleuck_101's avatar
    nleuck_101
    3 years ago

    ArchStanton 

    I would think they would be the same line.

     

nleuck_101's avatar
nleuck_101
Icon for Continued Contributor rankContinued Contributor
3 years ago

ArchStanton 

I see it now. VAR Known is the name of your measure. Name your measure something else and move the VAR Known in front of the FILTER.

 

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
3 years ago

Slope1 and Intercept are underlined in Red (Cannot find name messages)

  • nleuck_101's avatar
    nleuck_101
    Icon for Continued Contributor rankContinued Contributor
    3 years ago

    No need to worry about this.
    You can use LINESTX or LINEST by themselves and create new tables. The table will create a single row with 10 columns. Two of those columns are Slope1 and Intercept.