ability to plot multiple metrics on same slice

[Gauravshah]

Not sure if its the right place.

Looking for ability to plot more than one metric on the same chart. Its very common to see number of orders vs number of signups on the same chart by day.
It sounds similar to JOIN but it is slightly different Join is at the event level. Here I am looking for join at the metrics level.

I looked at couple of other issues related to join and it is pointed that we can materialise a view and the make use of superset over the view. But that is not always possible, given that superset is an amazing exploratory tool it hinders Analytics user to be able to explore data in such fashion requiring DBA to create views for each of the things that they want to explore.

Also backend might not support such joins, in our case we are using druid which doesn't support views/JOINS.

[xrmx]

I'm pretty sure that we have some kind of visualization that can display more than one metric at once, e.g time series - line chart.

[Gauravshah]

thanks @xrmx
time series & table lets me select 2 metrics yes. But it wouldn't let me select 2 queries.
So lets say sign_ups & orders are two tables then I can't do it.

In our case we have one data source where I can say event_type='order' count(*)== orders
and event_type='sign_up' count(*) == signups. But I couldn't find a way to plot/show this on one slice

[xrmx]

Thanks for clarifing, metrics in the slice context means what you call events :)

BTW for data queried by sqlalchemy you should be able to create the necessary view with sql lab without requiring a dba.

[Gauravshah]

Not sure if I explained it correctly. Lets say we have two data sources in druid "orders" and "signups" and I would like to plot these two by time on a table / graph. I am not sure of a simple way to do it.

[Gauravshah]

or lets say I want to plot page_views/active_users

[Gauravshah]

In simple terms if My active_users count require no filter and had to count distinct users & I had page views on numerator which I had to couple of filters I could not plot it on one slice.
looking for something like what grafana provides

[mistercrunch]

No easy solution for this apart from:

• changing your Druid datasource to have the superset of both (or more) datasources
• showing two different charts one bellow another
• request support for views (or something similar) in Druid

[Gauravshah]

Thanks @mistercrunch

[bondarchukd]

Hi everyone! I have the same problem. What is right solution of this?