Social Media Reports

SHANE EBERT asked on March 27, 2017 20:20

I successfully configured the LinkedIn app in Kentico, and can successfully run a report on Total Follower Count. I can embed this on a page with the Kentico webpart, where it asks for a date range and supplys a drop down for which LinkedIn account to populate the report from. To view a chart, I have to click "Update."

Is there anyway it can automatcially populate the report for the last 30 days?

The end goal is to embed the chart/page on a google site (using an iframe), but I just want the charts, I don't want to have to "Update" the report everytime I want to see it. Subscribing to the report is not an option.

I prefer not to see the Date range or drop down, just the chart.

How would I configure the report to function this way?

Thanks

reporting linkedin

Correct Answer

Rui Wang answered on March 27, 2017 21:11

If you delete the FromDate and ToDate in the parameter tab, then the Update button will go away.

Then in your SQL code for the report, set the date range like this, so the SQL script will get the current date automatically, instead picking up from the macro value in the parameters.

 SELECT [Date] AS StartTime ,T1.Hits FROM
  {%DatabaseSchema%}.Func_Analytics_EnsureDates ({%DatabaseSchema%}.Func_Analytics_DateTrim(GETDATE()-30,'day'),GETDATE(),'day') AS Dates   
  LEFT JOIN
  ...

0 votesVote for this answer Unmark Correct answer