superset 0.28.1 integrated echarts method #6883

mildrabbit · 2019-02-15T07:17:55Z

I want to integrate echarts into superset 0.28.1. How to use it

Llyfighting · 2019-02-16T09:16:06Z

You should install superset first，there are many related tutorials on the internet，you can learn from them. I'm doing the same thing now, and I have an unsolvable problem, Maybe we can talk to each other.

mildrabbit · 2019-02-18T01:02:52Z

@Llyfighting Thanks！ I have set up the development environment, also according to some of the information on the Internet to configure, but also encountered problems, has not been solved.

Llyfighting · 2019-02-18T08:28:11Z

An error occurred while rendering the visualization: TypeError: (0 , o.getColorFromScheme) is not a function

Have you ever had this problem?

mildrabbit · 2019-02-19T07:27:10Z

@Llyfighting no

mildrabbit · 2019-02-26T01:41:09Z

@Llyfighting 看了你的贴子，受益非浅，怎么联系你，有事请教

EmiyaSaber · 2019-04-18T09:05:25Z

你这个问题解决了吗？我在Windows下使用pip安装superset之后有好多博客当中的文件都找不到。很困扰

mildrabbit · 2019-04-18T09:07:41Z

不要在windows里装superset....

…

------------------ 原始邮件 ------------------ 发件人: "EmiyaSaber"<[email protected]>; 发送时间: 2019年4月18日(星期四) 下午5:06 收件人: "apache/incubator-superset"<[email protected]>; 抄送: "沐曦--刘志国"<[email protected]>; "Author"<[email protected]>; 主题: Re: [apache/incubator-superset] superset 0.28.1 integrated echartsmethod (#6883) 你这个问题解决了吗？我在Windows下使用pip安装superset之后有好多博客当中的文件都找不到。很困扰 — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

EmiyaSaber · 2019-04-18T09:12:14Z

那在什么环境下装比较好在 2019-04-18 17:08:37，"mildrabbit" <[email protected]> 写道：不要在windows里装superset....

…

------------------ 原始邮件 ------------------ 发件人: "EmiyaSaber"<[email protected]>; 发送时间: 2019年4月18日(星期四) 下午5:06 收件人: "apache/incubator-superset"<[email protected]>; 抄送: "沐曦--刘志国"<[email protected]>; "Author"<[email protected]>; 主题: Re: [apache/incubator-superset] superset 0.28.1 integrated echartsmethod (#6883) 你这个问题解决了吗？我在Windows下使用pip安装superset之后有好多博客当中的文件都找不到。很困扰 — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread. — You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

mildrabbit · 2019-04-18T09:54:57Z

我们是在centos上安装的。

…

------------------ 原始邮件 ------------------ 发件人: "EmiyaSaber"<[email protected]>; 发送时间: 2019年4月18日(星期四) 下午5:13 收件人: "apache/incubator-superset"<[email protected]>; 抄送: "沐曦--刘志国"<[email protected]>; "Author"<[email protected]>; 主题: Re: [apache/incubator-superset] superset 0.28.1 integrated echartsmethod (#6883) 那在什么环境下装比较好在 2019-04-18 17:08:37，"mildrabbit" <[email protected]> 写道：不要在windows里装superset....

------------------ 原始邮件 ------------------ 发件人: "EmiyaSaber"<[email protected]>; 发送时间: 2019年4月18日(星期四) 下午5:06 收件人: "apache/incubator-superset"<[email protected]>; 抄送: "沐曦--刘志国"<[email protected]>; "Author"<[email protected]>; 主题: Re: [apache/incubator-superset] superset 0.28.1 integrated echartsmethod (#6883) 你这个问题解决了吗？我在Windows下使用pip安装superset之后有好多博客当中的文件都找不到。很困扰 — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread. — You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

gbrian · 2019-06-03T11:46:03Z

Hi, Do you still working on this @mildrabbit @Llyfighting ?

mistercrunch · 2019-06-04T05:58:04Z

echarts looks pretty neat, I'd love to see integrations with Superset.

gbrian · 2019-06-04T06:15:45Z

@mistercrunch hold my beer! 🤣

hamza-iqbal-hi · 2019-06-10T13:30:42Z

Any news?

gbrian · 2019-06-11T09:53:35Z

WIP but slooow dut to fixing bugs. @mistercrunch is this the new way to go: @superset-ui/plugin-*? https://github.com/apache-superset/superset-ui-plugins

Found open question for echarts: apache-superset/superset-ui-plugins#76

mistercrunch · 2019-06-17T04:54:42Z

Yes @gbrian, that's the way to go. The whole npm link thing works but isn't ideal. There must be an easy way to work on the plugin locally in the main repo and port it once it's baked. @kristw said he's wrapping up some things around controls before documenting the process of adding a new viz.

hamza-iqbal-hi · 2019-06-25T13:35:21Z

@mistercrunch when will we be able to see echarts in superset, or a documentation for adding a new viz?

EmiyaSaber · 2019-07-04T03:23:54Z

I have already add some simple Echarts viz to superset, and it get worked. I worked on windows with python and JS. And we need npm to manage the JS file from superset.Everytime we change the JS file from superset , we need to run' npm run dev '.

thunter009 · 2019-07-09T15:31:51Z

@EmiyaSaber mind providing a link to a fork with the working echarts integration you mention? Would love to try testing it out on a private fork I maintain.

gbrian · 2019-07-15T11:09:23Z

Hi,

Have an intermediate step while developing the final Chart plugin. Is about using a modified version of the Markup visualization. It requieres just few changes on Superset (no need to deal with plugins repo currently).
Not a final solution but helps in the meantime 😄

Changes are:

Add Jinja2 templates
Add Query and data functionalities

CODE:


class MarkupViz(BaseViz):

    """Use html or markdown to create a free form widget"""

    viz_type = "markup"
    verbose_name = _("Markup")
    is_timeseries = False

    def should_be_timeseries(self):
        fd = self.form_data
        # TODO handle datasource-type-specific code in datasource
        conditions_met = (fd.get("granularity") and fd.get("granularity") != "all") or (
            fd.get("granularity_sqla") and fd.get("time_grain_sqla")
        )
        if fd.get("include_time") and not conditions_met:
            raise Exception(
                _("Pick a granularity in the Time section or " "uncheck 'Include Time'")
            )
        return fd.get("include_time")

    def query_obj(self):
        d = super().query_obj()
        fd = self.form_data

        if fd.get("all_columns") and (fd.get("groupby") or fd.get("metrics")):
            raise Exception(
                _(
                    "Choose either fields to [Group By] and [Metrics] or "
                    "[Columns], not both"
                )
            )

        sort_by = fd.get("timeseries_limit_metric")
        if fd.get("all_columns"):
            d["columns"] = fd.get("all_columns")
            d["groupby"] = []
            order_by_cols = fd.get("order_by_cols") or []
            d["orderby"] = [json.loads(t) for t in order_by_cols]
        elif sort_by:
            sort_by_label = utils.get_metric_name(sort_by)
            if sort_by_label not in utils.get_metric_names(d["metrics"]):
                d["metrics"] += [sort_by]
            d["orderby"] = [(sort_by, not fd.get("order_desc", True))]

        # Add all percent metrics that are not already in the list
        if "percent_metrics" in fd:
            d["metrics"] = d["metrics"] + list(
                filter(lambda m: m not in d["metrics"], fd["percent_metrics"] or [])
            )

        d["is_timeseries"] = self.should_be_timeseries()
        return d

    def get_code(self, df):
        code = self.form_data.get("code", "")
        processor = get_template_processor(self.datasource.database)
        return processor.process_template(code, data=df.to_dict('r'))

    def get_data(self, df):
        print("markup df:%s" % df)
        markup_type = self.form_data.get("markup_type")
        code = self.get_code(df)
        if markup_type == "markdown":
            code = markdown(code, extensions=['tables'])
        return dict(html=code, theme_css=get_css_manifest_files("theme"))

markup.js

import { t } from '@superset-ui/translation';

export default {
  controlPanelSections: [
    {
      label: t('GROUP BY'),
      description: t('Use this section if you want a query that aggregates'),
      expanded: true,
      controlSetRows: [
        ['groupby'],
        ['metrics'],
        ['percent_metrics'],
        ['timeseries_limit_metric', 'row_limit'],
        ['include_time', 'order_desc'],
      ],
    },
    {
      label: t('NOT GROUPED BY'),
      description: t('Use this section if you want to query atomic rows'),
      expanded: true,
      controlSetRows: [
        ['all_columns'],
        ['order_by_cols'],
        ['row_limit', null],
      ],
    },
    {
      label: t('Query'),
      expanded: true,
      controlSetRows: [
        ['adhoc_filters'],
      ],
    },
    {
      label: t('Options'),
      expanded: true,
      controlSetRows: [
        ['table_timestamp_format'],
        ['page_length', null],
        ['include_search', 'table_filter'],
        ['align_pn', 'color_pn'],
      ],
    },
    {
      label: t('Code'),
      expanded: true,
      controlSetRows: [
        ['markup_type'],
        ['code'],
      ],
    },
  ],
  controlOverrides: {
    metrics: {
      validators: [],
    },
  },
};

stale · 2019-09-13T11:52:15Z

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

mistercrunch · 2019-09-22T23:22:29Z

FYI I have a proof of concept up too. It's looking pretty neat.

gbrian · 2019-09-23T08:04:38Z

@mistercrunch ,
Cool, I'm following same approach as NVD3. Which branch is your work?

Currently it implements basic charts with the option "Emit filter" so had to do some changes around. Still WIP so hope I can share soon.

gbrian · 2019-09-23T08:05:18Z

https://github.com/apache/incubator-superset/tree/echarts_poc

maltoze · 2019-09-25T02:00:22Z

https://github.com/apache/incubator-superset/tree/echarts_poc

import EchartsScatterChartPlugin from '@superset-ui/superset-ui-plugin-echarts-scatter/src';

Where is '@superset-ui/superset-ui-plugin-echarts-scatter/src'? I can't find it. @gbrian @mistercrunch

kristw added the #question label Feb 15, 2019

gbrian mentioned this issue Jun 11, 2019

How do I add echarts in this project apache-superset/superset-ui-plugins#76

Open

stale bot added the inactive Inactive for >= 30 days label Sep 13, 2019

stale bot closed this as completed Sep 20, 2019

7aklhz mentioned this issue Mar 20, 2020

Add to superset ? apache/echarts#12310

Closed

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

superset 0.28.1 integrated echarts method #6883

superset 0.28.1 integrated echarts method #6883

mildrabbit commented Feb 15, 2019

Llyfighting commented Feb 16, 2019

mildrabbit commented Feb 18, 2019

Llyfighting commented Feb 18, 2019

mildrabbit commented Feb 19, 2019

mildrabbit commented Feb 26, 2019

EmiyaSaber commented Apr 18, 2019

mildrabbit commented Apr 18, 2019 via email

EmiyaSaber commented Apr 18, 2019 via email

mildrabbit commented Apr 18, 2019 via email

gbrian commented Jun 3, 2019

mistercrunch commented Jun 4, 2019

gbrian commented Jun 4, 2019

hamza-iqbal-hi commented Jun 10, 2019

gbrian commented Jun 11, 2019 •

edited

Loading

mistercrunch commented Jun 17, 2019

hamza-iqbal-hi commented Jun 25, 2019

EmiyaSaber commented Jul 4, 2019

thunter009 commented Jul 9, 2019

gbrian commented Jul 15, 2019

stale bot commented Sep 13, 2019

mistercrunch commented Sep 22, 2019

gbrian commented Sep 23, 2019 •

edited

Loading

gbrian commented Sep 23, 2019

maltoze commented Sep 25, 2019 •

edited

Loading

superset 0.28.1 integrated echarts method #6883

superset 0.28.1 integrated echarts method #6883

Comments

mildrabbit commented Feb 15, 2019

Llyfighting commented Feb 16, 2019

mildrabbit commented Feb 18, 2019

Llyfighting commented Feb 18, 2019

mildrabbit commented Feb 19, 2019

mildrabbit commented Feb 26, 2019

EmiyaSaber commented Apr 18, 2019

mildrabbit commented Apr 18, 2019 via email

EmiyaSaber commented Apr 18, 2019 via email

mildrabbit commented Apr 18, 2019 via email

gbrian commented Jun 3, 2019

mistercrunch commented Jun 4, 2019

gbrian commented Jun 4, 2019

hamza-iqbal-hi commented Jun 10, 2019

gbrian commented Jun 11, 2019 • edited Loading

mistercrunch commented Jun 17, 2019

hamza-iqbal-hi commented Jun 25, 2019

EmiyaSaber commented Jul 4, 2019

thunter009 commented Jul 9, 2019

gbrian commented Jul 15, 2019

stale bot commented Sep 13, 2019

mistercrunch commented Sep 22, 2019

gbrian commented Sep 23, 2019 • edited Loading

gbrian commented Sep 23, 2019

maltoze commented Sep 25, 2019 • edited Loading

gbrian commented Jun 11, 2019 •

edited

Loading

gbrian commented Sep 23, 2019 •

edited

Loading

maltoze commented Sep 25, 2019 •

edited

Loading