Forum Discussion

jereaallikko's avatar
jereaallikko
Icon for Helper III rankHelper III
4 years ago
Solved

Line chart showing values from two different tables

Hi,   I am trying to create a simple line chart showing data from two different tables.   Both tables contains several parameters, such as date, ID, person etc. There are over 1000 records, so I ...
Need Help
Tips and Tricks
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi jereaallikko 

     

    You need to have a Calendar/date table and add connect your tables to that date table. use date table dates as axis data and the value of your table as the value of the line chart.

    if you want to create a date table see this link:

    https://www.vahiddm.com/post/creating-calendar-table-with-3-steps

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

     

    Appreciate your Kudos!!

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

jereaallikko , You should create a date table and join it with date.

 

And there you can have a column

Custom = format([date], "YYYY \QQ MMM DD" )

 

Sort this on the date column