Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Unstructured Table

Hi Team,   Thank you so much for your help, now I have another query...   How can I work on Trend Analysis/Line chart in the below one.     Thanks, Kali
Need Help
  • lkalawski's avatar
    lkalawski
    6 years ago

    Hi Kalidass,

     

    To create a trend chart, you have to unpivot the table.

    You will get this view and then use year and Value to build a trend line.

    Result:

     



    _______________
    If I helped, please accept the solution and give kudos! 😀

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

Before generating any trend/line chart, you will have to modify the structure of the data, so that you can have a DATE column on your x-axis on the chart.

For this what you can do is following:

  1. Go to Edit Query section.
  2. Naviagte to the data-set that you have shown below.
  3. Select all the date columns - 2020 to 2028.
  4. Go to Transform and Unpivot the selected columns.
  5. You will send up with following columns:
    • Markets
    • Keys
    • Attribute
    • Value
  6. Attribute column will have date values - 2020 to 2028. Rename this column to DATE or whatever you want.
  7. Now you can use this column to generate some trend chart.

 

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati