Sum value for the last day

[#1]

Hi all!

I'm trying to do a expression that´s summarize the amount/value for the last day. I,ve a date field with the format YYYYMMDD and the field that a summurizing is integer.

Any one that have a good solution?

Thanks in advance!

[#2]

could you give a data sample? with result expected?

[#3]

Hi Larssbjorn,

I saw you have 2 similar topics now, one for week and one for per day... Perhaps a bit overkill; i hope you didn't plan to open one for quarter, year, decade etcetera 🙂

For me, your question is still a bit unclear.

[1] Last day of what? Of all values loaded? Or per week or month?

[2] Summarize...? Just a sum? or other way of summary (count or...?)

Can you give some more info?

[#4]

I use a expression like this but it doesn´t give me that result I expected:

sum({<DateField={"$(=Date(today()-1,'YYYYMMDD'))"}>} ValueField)

[#5]

A small demo-app would be handy, so we can check your problem. Could you attach that?

When you don't assign a label to your expression (as column heading) you can check (by hovering (mouseover) the column header...) what the setexpression is (e.g. if you today()-1 is calculated correctly).

I think your expression returns null, and that that is the reason why it goes wrong.

Perhaps this helps, otherwise I hope you can provide a small sample app with the problem.