Line Chart issue from two different tables

[pswain]

Hello team,

Iam having trouble to create Line chart from two different tables.  1 graph is coming proper, another graph is giving unique value.

We have two tables one table has 1000 rows and second table has 2000 rows, In both the tables there is no matching data columns,so we created index column to map the tables.while creating Line chart one table data is mismatching.

x-axis choosen Start time ( Month) column and y-axis selected Avg. of value.

can you please help us on this.

[jaideepnema · Accepted solution]

Hi @pswain ,

Can you help me understand from where you are using the Group Response % ,Group Resolution % and month fields ? If these are coming from three separate tables for example Month, Table 1 and Table 2 then i would recommend you to join your month column in Table 1 with the month column in month table and similarly the same scenario with table 2 as well. 

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

[pswain]

Hi,

I appended from both the table and put some condition column to get proper graph. 

I was able to resolve the issue.

Thanks,

Prasanjit