caitlinkedi / looker-pop-comparison Goto Github PK

Need to replace {% date_end anchor_date_range %} with TIMESTAMP_SUB({% date_end _pop_compare.anchor_date_range %}, INTERVAL 1 MICROSECOND) in 3 places (once in the model file and twice in the view file).

Otherwise, Looker returns an error "Unable to chart pivoted data when dimension PoP Comparison Anchor Dates has repeated values. This commonly happens when you create a query with a second dimension and hide that dimension from the chart." when the user selects "is in the past 1 year" as the anchor date range, Show Totals by Month, Compare to Previous Year.