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

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

This documentation is for Kyvos 2026.6.x. To view documentation for other Kyvos versions, click here.

This documentation is for Kyvos 2026.6.x. To view documentation for other Kyvos versions, click here.

When using Tableau with Kyvos, avoid date-range-defined calculated fields in the view, along with the calculated measure defined in the Kyvos SM, 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.

    image-20251121-143248.png
  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.

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

    image-20251121-143504.png

 

Copyright Kyvos, Inc. 2026. All rights reserved.