Extract monthly KPIs from a galleries lookup table

Helper to flatten the nested kpis$per_month entries from ww_galleries_lookup (or a similar lookup table) into a single tibble.

Usage

get_gallery_kpis_per_month(lookup)

Arguments

lookup

A tibble with columns waterworks, gallery and a list-column kpis as returned by compute_gallery_kpis().

Value

A tibble with monthly KPIs (gallery × calendar month), including the columns waterworks and gallery.