KNOWLEDGE BASE

Change Discrete Points Into A Line Chart


Published: 01 Dec 2022
Last Modified Date: 22 Jun 2023

Question

When there is NULL data the marks in the Line chart are disconnected and displayed as dots. How can I connect them and show as the line chart without filtering the data?

User-added imageUser-added image

Environment

  • Tableau Desktop

Answer

See the attached workbook downloadable from the right side.

1. Create a calculated field called index with the following calculation:
if isnull(SUM([points]))=false
then index()
END

2. Add index to Path on the Marks card.
User-added image

3. Confirm that index computes using Table(across).
Did this article resolve the issue?