Philip Flesher
04/11/2023, 5:07 PMIvana Gasparekova
04/11/2023, 5:29 PMPhilip Flesher
04/11/2023, 6:33 PMMoises Morales
04/11/2023, 9:07 PMPhilip Flesher
04/11/2023, 9:19 PMJakub Sterba
04/11/2023, 11:20 PMselect sum({fact/value})
• Metric revenue with applied local filter on region attribute translates to select {metric/revenue} where {label/region} in ("West")
• Simple arithmetic metrics like A+B translate to formula select ifnull({metric/a},0)+ifnull({metric/b},0)
• Show as percent metrics should work like select {metric/a} / (select {metric/a} by all other)
• Numeric range filters and ranking filters are applied as HAVING filters.
• The metrics which compare data to the same period a year ago use FOR PREVIOUS({attribute/date.year})
clauseProductboard
04/11/2023, 11:21 PMPhilip Flesher
04/11/2023, 11:55 PM