I am trying to create the yellow line but without the steps. I can use the cumulative sum and choose without empty and I will get the line I want. However, when I hover over the line in Timeline view, that value does not show up.
I want to create a measure that adds up the values but skips the empty cells and does not fill them with the value before it.
I have tried NonZero, CoalesceEmpty, CumulativeSum and every variation I try, even using multiple in one measure doesn’t work.
Hi @Kayris06,
It seems you use the “Timeline” chart type. This chart type determines what periods to return on the timeline based on the period length. If you want to see a more streamlined view, I recommend switching to the “Line” chart type and deciding what period to show in the Time dimension, for example, “Month” or “Quarter”. That will affect how the chart break points look.
If this does not help, please share more details about the report configuration, for example, definition of the report - Export and import report definitions. You can share it here or at support@eazybi.com with a reference to this community post.
Best,
Roberts // support@eazybi.com
