Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Please explain "weekly variation" ? Maybe you could post how the expected output would look like using your sample in the posted image?
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
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;
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.
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!
@alexandernatale It will be better if you can share on example with expected output
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