Skip to content

Instantly share code, notes, and snippets.

@23maverick23

23maverick23/project_percent_time_complete.sql

Created March 20, 2014 20:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save 23maverick23/9672591 to your computer and use it in GitHub Desktop.
Save 23maverick23/9672591 to your computer and use it in GitHub Desktop.
Download ZIP
NS: Project percent time complete
Raw
project_percent_time_complete.sql
'<style>.progress{overflow:hidden;height:18px;background-color:#ccc;border-radius:4px;-webkit-border-radius:4px;-moz-border-radius:4px;box-shadow:inset 0 1px 2px rgba(0,0,0,0.1);-moz-box-shadow:inset 0 1px 2px rgba(0,0,0,0.1);-webkit-box-shadow:inset 0 1px 2px rgba(0,0,0,0.1);}.progress-bar{float:left;width:0;height:100%;font-size:11px;line-height:18px;color:#fff;text-align:center;background-color:#428bca;box-shadow:inset 0 -1px 0 rgba(0,0,0,0.15);-webkit-box-shadow:inset 0 -1px 0 rgba(0,0,0,0.15);-moz-box-shadow:inset 0 -1px 0 rgba(0,0,0,0.15);-webkit-transition:width .6s ease;transition:width .6s ease;-moz-transition:width .6s ease;}</style><div class="progress">' || '<div class="progress-bar" style="width:' || CASE WHEN ROUND({percenttimecomplete}*100, 1) >= 100.0 THEN 100 ELSE ROUND({percenttimecomplete}*100, 1) END || '%;"> ' || ROUND({percenttimecomplete}*100, 1) || '%</div></div>'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment