Forum Discussion
Deneb: implicitly calculated columns messing up x axis positioning for labels
Thanks for the response. I discovered that my problem was unrelated to the use of a window function. The extra columns are created when the "stack" property is enabled. I had it turned on while experimenting to solve an unrelated issue. When I set "stack" to "false", the additional columns disappeared, and labels were positioned absolutely (instead of relative to the _start and _end columns that were created by the "stack" property). I have not tried the cumulative sum function - that could be an elegant way of achieving the desired positioning. I found another way to achieve the desired result.
Hello
It appears that the x-axis location is acting in an unanticipated way due to the "DifferenceHalf" field. Have you verified that each data point's field is being computed correctly by the transform logic? Small differences in the computation can occasionally cause the visual to be out of alignment. I'd be pleased to check over and assist with troubleshooting if you could provide more information about the transform or a sample of your code!
Regards
Ava Daisy
Thanks for the response! I have already solved this issue, but your suggestion was right on the money - DifferenceHalf was not being calculated correctly. However, this issue was confounded by the fact that I had the "stack" property enabled. The stack property adds each calculated value of the field to the prior calculated value (these running totals appear to be tracked in the _start and _end columns I referenced), meaning that in addition to being calculated incorrectly, each new incorrect DifferenceHalf value was added to the running total of the prior values for that series, resulting in some very odd label positioning no matter how I calculated DifferenceHalf. Once I turned "stack" off, I was able to troubleshoot and get DifferenceHalf working correctly using the values I needed. The chart is now working as desired. Lots of user error here!