Hi!
We have a large contour analysis, which starts off by joining two fairly large datasets, and then continues with various filters, expressions, etc.
At the end, there is a pivot table and a chart of count over time. However, these two outputs are displaying different results from each other, and both are wrong when compared to the underlying data. If the analysis is saved to a dataset, and the charts/pivot tables are built from this dataset instead, this will provide the correct result.
Is there any way to avoid having to save it to a dataset at this stage? Or any guidance on when charts and pivot tables shouldn’t be relied on due to analysis complexity?