I'm wondering if this is intended behavior and how to adjust it.
I have a simple widget, shown below that measures a single metric (Gross Production) by year. fct.gross_production and dim_date.date are the only two elements being used.
If I turn on the GROWTH, GROWTHPASTYEAR or GROWTHRATE formulas they add "2020" to my X-Axis. 2020 has the value -100%, which technically isn't wrong, as there is $0 of gross production in 2020, but I'm hoping to not have 2020 appear when using these formulas. The behavior appears similar when looking at Month/Quarter, whatever, it automatically adds the next element in the series (presumably because the denominator is NOT NULL, in my case 2019).
Please sign in to leave a comment.