I have a list of payments and many of those are on repeated days. I would like to visualize the nr of days based on every row but I don't want to sum the values for the repeated dates.
I don't know if it's possible but I need a timeline with repeated dates and a chart with the number of days. Not sum, not average.
The one attached is with SUM of nr. of days. for rows with the same date. Is this possible?
You may take advantage of the Legend field.
Thank you for your answer. It's not really doing it for me.
What I'm trying to visualize is the days passed from a Due date for an invoice and the posting date for the same invoice.
Due to the nature of this table, there are many lines with the same date and I don't want to sum the amount of days.
The composition of the current chart is this:
As per your suggestion, I created a calculated column:
and I tried to create a line chart and setting this column in the legend field as per the your reference post suggested, but there is someting wrong.