...
| Code Block | ||||
|---|---|---|---|---|
| ||||
variables as (
select
'ticketst' as calculate_by, -- choose the basement of calculation: tickets or story points
7 as iteration_duration, --in days
20 as iterations_to_analyze,
20 as future_iterations_num, --number of iterations to make forecast for
'no' as scope_change, --yes/no
200 as division_step --must be an even number!
),
types as (
select a.* from (values ('bug'), ('task')) a (ticket_type) -- add ticket types to make forecast
) |
...