Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have a problem.
I have a data table of Covid19. In this table i have
| Date | Region | Recovered | Death | Hospitalized | ecc..
The values of the patients are cumulative: for each day I have the total value but no the incremetal value for day.
My goal it's calculate the month trend --> for example for May I would like to calculate the difference of recovered at the end of the month and at the beginning of the month to understand the monthly increase.
I also have the data table I have a master calendar table.
I would like to realize a histogram o another chart..
Suggest?
@Michael_Tarallo please help me 😓
Hello Alexandra,
May I suggest that you add some dummy data to your question. And then show us a chart of what you expect the data to look like? It makes people want to help you because the objective is clearly shown.
thanks for the reply @JustinDallas
I attached a example data and what i would create a data or graph..
To complete the discussion, the problem can also be seen in this other way: Having an initial warehouse with inventory at the beginning of the month and one at the end of the month, I want to evaluate the increase / decrease of inventories in the warehouse considering therefore the initial inventory on day 1 of the month and the final inventory on day 31 of the same month. This calculation, for all months