[jira] [Created] (ZEPPELIN-3926) Drill down for record count

["Pradeep (JIRA)" <ji...@apache.org>]

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)