Incubator-superset: Add "metric" to show actual value of column, i.e. no aggregate

[brylie]

We have a query that returns timeseries data with two columns:

• date
• count

I would like to simply graph the data as a line chart. However, when selecting the line chart, it requires that I choose a metric for the data, e.g. sum, average, etc

Since my data are already in the desired form, how can I just tell the chart to use the data as-is?

Note: I can also select the "sum" metric, since I am not performing any additional aggregation, but this seems a bit "kludgy".

[rumbin]

You can use a workaround:
Just define an aggregate that would yield the original value if only one element per group is present, like, e.g. sum, min, max, avg.
Then, make sure you configure your chart to use the original time granularity.

However, this workaround is only valid, as long as the timestamps are all distinct. Otherwise the grouping would actually aggregate more than one value...

[brylie]

Good workaround.

I still would like to see this as a feature. I.e. aggregations should be optional, since they may be done during the query.

[stale[bot]]

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.

[brylie]

Bump.

[stale[bot]]

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.

[khuranabalvinder]

Bump

[drewgonzales360]

Bump

[benmaier]

I'd like to see this feature, too. having data in two columns and then plotting the first column against the second column is the base case, in my opinion. it's very confusing to not have this as an option for a first-time user (such as myself).

[villebro]

This shouldn't be too difficult to implement. I'll take a stab at adding this in the coming weeks.

[junlincc]

@villebro I would love to see this feature happen, let's make it post 1.0 item! added to roadmap inbox :) https://github.com/apache-superset/superset-roadmap/projects/1