aggr(),rank(),if()

mert1917 — Sat, 16 Nov 2024 21:24:10 GMT

Hi all:),

I have a problem could you help to me please.

I have 3 columns(Date,Hours,Count(I3) )

how can i take sum of up to this hour yesterday?

How do I get 50 value?

thank you so much..

Date ,hours, Count(I3), target
2019.02.15, 13, 20, 50 (Now)
2019.02.15, 12, 19,
2019.02.15, 11, 17,
2019.02.15, 10, 16,
2019.02.15, 9, 15,
2019.02.14, 17, 55,
2019.02.14, 16, 26,
2019.02.14, 15, 15,
2019.02.14, 14 45,
2019.02.14, 13, 10, 50
2019.02.14, 12, 10,
2019.02.14, 11, 10,
2019.02.14, 10, 10,
2019.02.14, 9, 10,

Re: aggr(),rank(),if()

Wlad_Masi — Mon, 18 Mar 2019 15:39:12 GMT

What is the logic that should be used to calculate the sum?
Do you need it calculates in the script or it could be calculated in the visualization layer?

topic aggr(),rank(),if() in App Development

aggr(),rank(),if()

Re: aggr(),rank(),if()