Avoid using a date-range-defined calculated field in the view.

When using Tableau with Kyvos, avoid date-range-defined calculated fields in the view, along with the calculated measure defined in the Kyvos semantic model, to prevent data inaccuracy. Instead, apply a filter to the calculated field for reliable results. Using date-range calculations in the view can lead to incorrect aggregations and misleading visualizations.

1. Create a calculated field with a defined date range. Eg, Date range.

   Open

   

2. Drag the Date range and a calculated measure (defined in Kyvos SM) into the view. The user will receive incorrect values due to incorrect aggregation.

   Open

   

3. To get the correct values, users need to use a calculated field in the filter instead of the view.

   Open