Pradeep created ZEPPELIN-3926:
---------------------------------
Summary: Drill down for record count
Key: ZEPPELIN-3926
URL: https://issues.apache.org/jira/browse/ZEPPELIN-3926
Project: Zeppelin
Issue Type: New Feature
Environment: RHEL 6
Reporter: Pradeep
Attachments: zeppelinScreenshot.PNG
I am planning to use apache zeppelin with Postgresql 9.5. My sql query and data
is below. I want all the records to open when I click on the numbers. How to
achieve that.
Lets say when I click on count 2 i.e in the first row, I want zeppelin to open
a window with those two records.. Can any one guide me how to achieve that?
{code:java}
// code placeholder
{code}
%pgsql SELECT final_result.acivity_name as ActivityName,jan, feb, mar, apr,
may, jun, jul, aug, sep, oct, nov, dec FROM crosstab($$SELECT acivity_name as
ActivityName,to_char(activity_start_date,'MON') as MON, count(acivity_name) as
ActvityCount FROM public.activity_details group by 1,2,activity_start_date
order by 1,2,activity_start_date $$,$$VALUES ('JAN'::text), ('FEB'), ('MAR'),
('APR'), ('MAY'), ('JUN') , ('JUL'), ('AUG'), ('SEP'), ('OCT'), ('NOV'),
('DEC')$$) AS final_result(Acivity_name character varying(100), Jan bigint,Feb
bigint,Mar bigint,Apr bigint, May bigint,Jun bigint,Jul bigint,Aug bigint, Sep
bigint,Oct bigint,Nov bigint,Dec bigint) UNION ALL SELECT 'SubTotal' as
Grand,sum(jan), sum(feb), sum(mar), sum(apr), sum(may), sum(jun), sum(jul),
sum(aug), sum(sep), sum(oct), sum(nov), sum(dec) FROM crosstab($$SELECT
acivity_name as ActivityName,to_char(activity_start_date,'MON') as MON,
count(acivity_name) as ActvityCount FROM public.activity_details group by
1,2,activity_start_date order by 1,2,activity_start_date $$,$$VALUES
('JAN'::text), ('FEB'), ('MAR'), ('APR'), ('MAY'), ('JUN') , ('JUL'), ('AUG'),
('SEP'), ('OCT'), ('NOV'), ('DEC')$$) AS final_result(Acivity_name character
varying(100), Jan bigint,Feb bigint,Mar bigint,Apr bigint, May bigint,Jun
bigint,Jul bigint,Aug bigint, Sep bigint,Oct bigint,Nov bigint,Dec bigint)
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
