Trend line in a chart

carla Janssen
carla Janssen Customer
Third Anniversary Level 200: Building A Planning Solution in Board Level 100: Foundations of Building in Board First Comment
edited July 2022 in Platform
Hello,

I want to make a trend line in a chart like de red line.
I tried with the time functions Trend but that does not work.


image
image

Someone a solution ?

Kind regards

------------------------------
carla Janssen
Business intelligence specialist
Attero
Netherlands
------------------------------

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    edited July 2022
    Hi @carla Janssen,

    how did you configure your chart? If I do this in 12.3 I get the following result:
    imageI'd expect that this is what you would like to achieve.
    The layout is defined this way

    imageLet me know if you have further questions.

    Kind regards
    Helmut

    ------------------------------
    Helmut Heimann
    Senior Consultant
    Board Community
    Germany
    ------------------------------
    -------------------------------------------
  • carla Janssen
    carla Janssen Customer
    Third Anniversary Level 200: Building A Planning Solution in Board Level 100: Foundations of Building in Board First Comment
    edited July 2022
    Thank you Helmut,

    I think it's because i don't have any historical data in te cube.
    It works with another cube
    image

    Kind regards,

    Carla Janssen

    ------------------------------
    carla Janssen
    Business intelligence specialist
    Attero
    Netherlands
    ------------------------------
    -------------------------------------------
  • Nitish Subramanian
    Nitish Subramanian Active Partner
    Fourth Anniversary 25 Up Votes Name Dropper Level 100: Foundations of Building in Board
    edited August 2022
    Edit: Ignore this, creating a new layout worked fine.

    Can you please help me with the configuration here? I tried doing something similar, but not sure why am I seeing only bar instead of a combination of bar+line.
    image



    ------------------------------
    Nitish Subramanian
    Senior Consultant
    Board Community
    India
    ------------------------------
    -------------------------------------------
  • Uwe Schlünz
    Uwe Schlünz Employee
    Fourth Anniversary Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board First Comment
    edited September 2022
    Hello Nitish,

    in the options for the Chart you can change the Series Type like below:
    image
    Regards,
    Uwe

    ------------------------------
    Uwe Schlünz
    Support Tech Specialist
    Board Community
    Germany
    ------------------------------
    -------------------------------------------

Categories