Hello, I am struggling to convert total number of metric value from number into percentage of total value, in this case is browser type -- and it should be shown in time series bucket function, At the moment, I am able to show based on number using following queries in time series (see attached picture) SELECT series(eventTimestamp, '1m'), count(browser) AS "Firefox" FROM browser_records WHERE browser = "Firefox" SELECT series(eventTimestamp, '1m'), count(browser) AS "Non-Firefox" FROM browser_records WHERE browser != "Firefox" SELECT series(eventTimestamp, '1m'), count(*) AS "Total" FROM browser_records However, I am unable to convert it into percentage (%). I know there is filter function e.g. : SELECT 100*filter(count(*), browser = "Firefox") / count(*) AS "% Firefox" FROM browser_records or SELECT 100*filter(count(*), browser != "Firefox") / count(*) AS "% Non-Firefox" FROM browser_records BUT it will only return single value, not in time series as I expected. How to combine series bucketing function and filter function to get percentage number browser in time series? Anyone has experience before?
... View more