Forum Discussion

Mohamed-Sayed's avatar
Mohamed-Sayed
Frequent Visitor
1 year ago
Solved

I need to make line chart

Hello    I need to make line chart, and I have unpivot data included column named "Cat.", this column included 3 cat [Ratio, Defects, Sales]   I need to make line chart for only ratio by monthly ...
General Comment
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
1 year ago

Mohamed-Sayed Is this the expected result you are looking for?

 

 

Mohamed-Sayed's avatar
Mohamed-Sayed
Frequent Visitor
1 year ago

Yes, this is the expected result, 

Can I know the steps ?

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    1 year ago

    Mohamed-Sayed The steps are available in the screen shot.

    Step1: Take Line chart

    Step2: Take "Fiscal Month" on X-axis and "Sum of Values" on Y-axis.
    Step3: Take the "Cat" column on filter pan and select only "Ratio".

     

    You can re-check my last post screen shot for a reference.