Showing results for 
Search instead for 
Did you mean: 
setis Member

Visualization with repeated days

Hi all, 


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?days.PNG

Community Support Team
Community Support Team

Re: Visualization with repeated days



You may take advantage of the Legend field.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
setis Member

Re: Visualization with repeated days

Dear Sam, 


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.