Dashboard widget configuration

Buttons

All the below properties are required for the button

• ButtonGlyph: Icon of the button (3 options)
  • FontAwesome glyph: fa-home
  • Icon URL: http://starwars.com/LukeSkyWalker.png
  • Single character: ”P”
• Title: Text below the icon
• Content: Url of the button

Query

Sample: Limited status distribution

 SELECT s.Status, count(*)
 FROM data_leads1 as d
 JOIN formstatus as s ON  s.StatusID = d.StatusID 
 WHERE d.StatusID IN (11344,11343,11345)
 GROUP BY 1

Special keywords / variables

• %UserID%
• %ExclusiveGroupID%

• %GroupListSql%
• %ExclusiveGroupListSql%

• %AndRecordFilter%