'Calculate percentage of values based on different dates
Want to get this [1]: https://i.stack.imgur.com/8dXSG.png so i have 2018 as index period and need calculate difference in each year with 2018: example 2018 and 2019, 2018 and 2020, 2018 and 2021...
Need to use something like summarize total=sum(value) | where date == '2018-01-01' but how iterate each value to 2024 year?
Please help, checked Kusto doc but hav'nt find answer how to do that :(
i have this table
datatable(Value:int, Date:datetime)
[2121, datetime(2018-01-01), //100% as this is index perios
5645, datetime(2019-01-01), // will be 266%
5123, datetime(2020-01-01),
4478, datetime(2024-01-01),
9965, datetime(2024-01-01),
7645, datetime(2024-01-01),
];
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
