I wanted to get work statistics from the date of the first entry. I had problems with the while loop as I had to specify an iteration limit.
In order to find out the number of days since the first entry, I decided to subtract the date of the first entry from today’s date.
>>>>>>UPDATED INFO! CLICK HERE<<<<<<<
I then used the resulting number for my while loop.
#COUNTING DAYS
field_name = 'date_added'
obj = Addinfo.objects.first()
field_object = Addinfo._meta.get_field(field_name)
first_date_full = field_object.value_from_object(obj)
first_date = first_date_full.date()
delta = datetime.now().date() - first_date
n = delta.days
x = []
y = []
i = 0
while i<=n:
daywork = datetime.now().day -i
dayview = Addinfo.objects.filter(date_added__day=daywork).values_list('work_minutes', flat=True)
y.append(sum([int(minn) for minn in dayview]))
x.append(i)
i += 1
chart = get_plot_svg(x, y)
