Forum Discussion

jereaallikko's avatar
jereaallikko
Helper 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!!

     

jereaallikko's avatar
jereaallikko
Helper III
4 years ago

Hi VahidDM PaulDBrown amitchandak,

 

Thanks for your replies, all of them were helpful. I got the problem solved by creating the date table with instructions by VahidDM. Then I connected the date columns from both tables to date table. Needed to make sure that each column was the type of "date" and not f.ex "date/time".

 

Thanks everyone.

 

BR,

Jere