GitHub user alexdonskikh created a discussion: How to create a chart with advanced window functions in metrics?
Hi all! Just starting to get familiar with Superset - a lovely tool, but still I face some issues with understanding its' functionality in terms of charts. My dataframe has the following structure: month-segment-item_category-revenue What I want is to get a table chart with the following structure: 1) segment 2) AVG(monthly_revenue) The problem is that firstly I need to GROUP BY month, segment (and drop a dimension of a category), measure SUM(revenue) and then to measure AVG of this monthly revenue, but I still don't understand how to do it with a metric in the chart itself. Of course I could do the regrouping before that (dropping category dimension) and then make a chart from this dataframe, but what if i still need my raw structure (For example, I want user to filter out some categories and then get this table chart values OR I want to have in my table this metric as well as some category-level metrics)? Would appreciate any help! GitHub link: https://github.com/apache/superset/discussions/34572 ---- This is an automatically sent email for notifications@superset.apache.org. To unsubscribe, please send an email to: notifications-unsubscr...@superset.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
