How to make chart clickable? RSS

• • Reply
  

  Priya621

  Member

  8 Points

  31 Posts

  How to make chart clickable?

  Feb 14, 2013 06:48 PM|LINK

  Hi,

  My storedprocedure query is as follows:

  Select Sum(Case When EntryDate between DATEADD(dd, -7, GETDATE()) AND GETDATE() Then 1 Else 0 End) As 'onetosevendays'
  ,Sum(Case When EntryDate between DATEADD(dd, -14, GETDATE()) AND  DATEADD(dd, -7, GETDATE()) Then 1 Else 0 End) As 'seventofourteendays',
  Sum(Case When EntryDate between DATEADD(dd, -21, GETDATE()) AND DATEADD(dd, -14, GETDATE()) Then 1 Else 0 End) As 'fourteentotwentyonedays',
  Sum(Case When EntryDate between DATEADD(dd, -30, GETDATE()) AND DATEADD(dd, -21, GETDATE()) Then 1 Else 0 End) As 'twentyonetothirtydays',
  Sum(Case When EntryDate< DATEADD(dd, -30, GETDATE()) then 1 else 0 end) as 'thirtyandabovedays' From Master

  I am having the storedprocedure query result as :

  onetosevendays    seventofourteendays    fourteentotwentyonedays    twentyonetothirtydays    thirtyandabovedays
     6                                   11                                 7                                    1                                 3

  These are the list of records in table which are according to Dates entered from current date.

  Now I need to display these values in chart.

  Please help me how to get the chart output as:

  http://www.mediafire.com/view/?9d9y4lac5mjpxs7

  and when I click on the 1-7 Days column on chart, the 6 records under it should be displayed in GridView.

  Is it possible?

  Please help me !!!

  Its Urgent!!!

  • Edited by Priya621 on Feb 14, 2013 06:48 PM
  • Edited by Priya621 on Feb 14, 2013 07:10 PM
  • Edited by Priya621 on Feb 14, 2013 07:18 PM
  • Edited by Priya621 on Feb 15, 2013 03:46 AM
• • Reply
  

  Ilikeit

  Member

  288 Points

  73 Posts

  Re: How to make chart clickable?

  Feb 22, 2013 02:37 AM|LINK

  http://splunk-base.splunk.com/answers/36383/make-charts-clickable