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.

     

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

Yes that fixed it, I should have spotted that myself.

However, I know get this, there is something up with Slop1 & Intercept as they are marked RED

 

 

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

ArchStanton 
I have the same thing with mine but it works just fine.

 

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

    ArchStanton 

    I would think they would be the same line.

     

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

    Thanks, I've finally got it to work ğŸ˜Š

    I've notice the trendline is far steeper with your Variable (see solid line in top line graph) compared to when I use the inbuilt Trendline using the Continuous x Axis date range. This inbuilt range has every other month missing which is why I'm desperate for an alternative option.

    I guess I need to decide which one to use. My only other option is to Snip an image of the the x axis with complete months and paste them over in Powerpoint when this get presented, incredible we still have to do this in 2023!

    Thanks for all of your help!

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

     with same Y Axis set at Zero:

     

     

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

    Thanks for helping me with this, much appreciated!

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

    as per screenshot, one is far steeper than the other. Its fine though, I can use either