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 li...
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

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