Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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--
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
Click exclude null values on your dimension might sort it.
I was able to resolve the issue using the group by statement.