Trend line in a chart

Options
carla Janssen
carla Janssen Customer
Level 200: Leveraging Board for Business Insights Level 100: Foundations of Building in Board First Anniversary 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
    March Badge of the Month February Badge of the Month Community Captain April Badge of the Month
    edited July 2022
    Options
    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
    Level 200: Leveraging Board for Business Insights Level 100: Foundations of Building in Board First Anniversary First Comment
    edited July 2022
    Options
    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
    Name Dropper First Anniversary Level 100: Foundations of Building in Board First Comment
    edited August 2022
    Options
    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
    First Anniversary Level 100: Foundations of Building in Board Level 200: Leveraging Board for Business Insights First Comment
    edited September 2022
    Options
    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