I would like to collapse the null values in my timeseries

[jleefjcapital]

Hi everyone,

I have reassigned data points from a field called [value] into two separate data points called [Alabama_NF_thous] and [Alabama_3m_thous]. 

When I add both series to the table, I get duplicate dates.  Is there a way to collapse the fields so that there's only 1 date per data point?   Here's a screenshot of what I'm seeing--

[NZFei]

If you only want to do it in the front you can change [Alabama_NF_thous] and [Alabama_3m_thous] from dimension to Measure (sum them up).

Or you can do it in the script (sum them up and group by dimensions)

Fei

[ogster1974]

Click exclude null values on your dimension might sort it.

[jleefjcapital]

I was able to resolve the issue using the group by statement.