Line chart with nulls

[nakuldev]

Hi,

In line chart while showing values I am getting all the countries data but while trying to populate same in %, country Malaysia is getting missed. I figured out that the issue is due to JOIN. I have joined Forex table to CPI table. CPI table have dates for Malaysia starting  from 2003 where Forex table have dates from 2015.  I tried with link table, composite keys and tried many ways and could not achieve it. Could someone help me with this issue.

Please find the attached demo.

[sunny_talwar · Accepted solution]

Try this

1/(Sum( Exchange_Rate)/FirstSortedValue({<Exchange_Rate = {"*"}>}DISTINCT TOTAL <Index_Country>  Exchange_Rate,CPIFX_Date))

[nakuldev]

Thank you Sunny! You are pretty awesome in solving such issues.