Col series chart has issues with slices

[fdmsaraiva]

In my app Chart views of type Col series and Col series [stack] are not working as expected with slices, rendering graphs with all rows of the slice’s parent table, instead of just the subset of rows of the selected slice.

My setup is that I have a Months table with around 200 unique rows, where a month is uniquely represented as YYYYMM, and I have a Months with orders slice which currently funnels down those 200 rows to just 4.

When I apply a Col series or Col series [stack] chart to this slice, the x axis shows all 200 months of the parent table, instead of the expected 4 of the slice.

Here’s a screencast to illustrate:

[fdmsaraiva]

Upon further debug, it appears the issue is that these two types of charts are filling in the series in the x-axis with generated values that are not present in the dataset.

Eg, 201860 is not a valid month in the YYYYMM format I’m using for the Key column of the Months table, and it is not in the parent dataset nor the slice, yet it is is being rendered along with dozens other generated numbers in the x-axis:

[fdmsaraiva]

I worked around the issue by setting the type of the Key column of the Months table to Text instead of Number. This prevents the x-axis from showing generated values out of the bounds of the slice. Still, this workaround is not at all intuitive and might not be viable in all cases.