topic Re: Weekly incremental with total data in Management & Governance

Weekly incremental with total data

alexandernatale — Fri, 02 Apr 2021 08:41:48 GMT

hi to all the experts of the forum

I have a problem that, however trivial, I cannot solve.

I have a table made as in the figure.

Sum (TIR) indicates the daily value of the inventory. That is how many pieces there are daily. I would like to calculate the WEEKLY variation and report it on a graph. Come can I do?

Re: Weekly incremental with total data

Vegar — Mon, 19 Oct 2020 16:09:55 GMT

Please explain "weekly variation" ? Maybe you could post how the expected output would look like using your sample in the posted image?

Re: Weekly incremental with total data

alexandernatale — Mon, 19 Oct 2020 17:00:55 GMT

Hello @Vegar and thanks for reply!

I would like to see the weekly increase. In a graph for example, as if the time scale were the week and it showed me the increase / decrease

I hope I was clear

Re: Weekly incremental with total data

Vegar — Mon, 19 Oct 2020 18:21:33 GMT

If you are able to make adjustment in your Load script then you could just add a week field like I've done below.

LOAD

Date,

Week(Date) as Week,

WeekName(Date) as YearWeek,

TIR

From YourSource;

Re: Weekly incremental with total data

alexandernatale — Mon, 19 Oct 2020 20:20:33 GMT

yes I have already made the change to the script ... the problem is that the daily difference and then the weekly sum are not calculated. Can you help me? Basically, the formula should calculate the difference between the individual days (because TIR is nothing more than the daily stock) and then add it weekly. In this way, I can measure the weekly variation.

Re: Weekly incremental with total data

alexandernatale — Thu, 22 Oct 2020 21:25:21 GMT

@sunny_talwar

I ask you to help me since you have already done it perfectly in the past!

I try: =sum({<Data={'$(=weekstart(Data))'}>} TIR)-sum({<Data={'$(=endstart(Data))'}>} TIR)

but don't work.

Any suggestions? Tnx!

Re: Weekly incremental with total data

Kushal_Chawda — Thu, 22 Oct 2020 21:29:56 GMT

@alexandernatale It will be better if you can share on example with expected output

Re: Weekly incremental with total data

alexandernatale — Fri, 23 Oct 2020 11:17:43 GMT

thanks @Kushal_Chawda for the reply!

I'd like a weekly difference..from this table

to this table:

In the first table, the =sum(TIR) daily, is the value of the stock.

I want to know, weekly, the change in stock