jomach commented on issue #12729: URL: https://github.com/apache/superset/issues/12729#issuecomment-1126784902
> > but for multi fact, there are none !!!, unless you support nested table which is a pain !!! or merin multiple fact with different grains which is not good IMO > > > > Why is there no workaround for multiple facts? It is not that difficult. And all that makes that SQL complicated are logical decisions, which the UI must provide as switches as well. So it won't be that much easier. > > > > ``` > > create view actual_vs_plan as > > select year, cost_center_grp, sum(actual), sum(plan) from ( > > select year, cost_center_grp, actual, null as plan from fact_co > > union all > > select year, cost_center_grp, null as actual, plan from fact_p where version = 1 > > ) > > group by year, cost_center_grp; > > ``` > > > > With this approach you need to read most of the things ans perform a distinct. Further more you are not leaving the user the option to play with your dashboard. It's kind of hardcoded -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
