linking date from 2 tables

[Sathvik123]

Hello All,

I have report where I am having 2 tables chat and call having column recorddate.

I am creating a chart where I need to show health index coming from both the tables fields.

From chat table:

KPIChatTime = SWITCH(TRUE(),

[Chatmins] <=20, 5,

 [Chatmins] <=25  , 4,

 [Chatmins] <=27, 3,

 [Chatmins]  <=30, 2,

1)

From calltable:

KPICallTime = SWITCH(TRUE(),

[callmins] <=20, 5,

[callmins] <=25  , 4,

[callmins] <=27, 3,

[callmins] <=30, 2,

1)

Now I need to show a page which has recorddate and health index calculated from both the above tables.

HealthIndex=(callmins*2+chatmins*3)/(callmins+chatmins)                (just example calculation)

But If I take recorddate from any of the above tables I am getting wrong health index .because calculated field values are coming wrong for other table.

If I take record date from call table then chat table values coming wrong and vice versa

I think I need to create a table for record date and link.

Not sure how to fix this..

Could any one please help

[Idrissshatila]

Hello @Sathvik123 ,

You could create a seperate date table that you connect to it both tables using the date column, and then use this new date table in your visualizations.
 you could check this link https://www.youtube.com/watch?v=-li7sxUxEqA

or this one

https://youtu.be/WybnTHDl-AM

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin