[ZEPPELIN-3926] Drill down for record count

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: usability

Environment

RHEL 6

• Flags: Important
• Assignee: Unassigned
• Reporter: Pradeep
• Created: 27/Dec/18 05:50
• Updated: 27/Dec/18 05:53

Description

 
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?

%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)