Uploaded image for project: 'Zeppelin'
  1. Zeppelin
  2. ZEPPELIN-3926

Drill down for record count

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Environment:

      RHEL 6

    • Flags:
      Important

      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)
      

       

       

        Attachments

        1. zeppelinScreenshot.PNG
          17 kB
          Pradeep

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Pradeep.sreeram Pradeep
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: