Forum Discussion

BIswajit_Das's avatar
BIswajit_Das
Impactful Individual
2 years ago
Solved

Line Chart

Hello,

I have a table like

x             y                 z

2023       23              22

2022       33              10

2021       20              30

and i want to visualize this data using line chart

Any Ideas
Thanks & Regards

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi BIswajit_Das ,

    Which field you are applying on Y-axis field of visual? What's the data type of them? Please change the data type as Number. Then you can choose the proper aggregation for that field when create line chart...

    Change data type as Number

    Create line chart

    Best Regards

5 Replies

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    Hi BIswajit_Das 
    You can visualize using line chart like below.

     

    I have taken your X value on x axis and Y & Z value on y axis.

    I hope I answered your question!

     

  • johnyip's avatar
    johnyip
    Solution Sage
    2 years ago

    BIswajit_Das ,

    since you have edited your questions to include "z", please find my asnwer as below.

     

    I don't recommend using secondary y-axis as the scale of y and z would then be different, thus possibly causing confusion when you aim to compare y and z.

    • BIswajit_Das's avatar
      BIswajit_Das
      Impactful Individual
      2 years ago

      But when i'm using line chart there's no option for MAX() or anything else

      here it's just count and distinct count

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi BIswajit_Das ,

        Which field you are applying on Y-axis field of visual? What's the data type of them? Please change the data type as Number. Then you can choose the proper aggregation for that field when create line chart...

        Change data type as Number

        Create line chart

        Best Regards