XSL Dashboard

Previously I had some issues trying to display SharePoint List data as rollups using a DataView Web Part (DVWP).  The problem I had is in remembering how to do a count of a query for every row that satisfies a condition, like a status or category.

The trick is creating variables and then calling the variables later, which really helps in creating percentages.

These 2 variables are default with every DVWP:
  <xsl:variable name="Rows" select="/dsQueryResponse/Rows/Row"/>
  <xsl:variable name="dvt_RowCount" select="count($Rows)"/>
You can call the total number of items in a list like this:
  <xsl:value-of select="$dvt_RowCount"/>

Here is an example of a way to show the number of items in a list split up by status.  Status is a drop-down choice column with 3 values: (Input, In Progress, Complete)

<xsl:variable name="InputCount" select="count(/dsQueryResponse/Rows/Row[normalize-space(@Status)='Input'])" />
<xsl:variable name="InProgressCount" select="count(/dsQueryResponse/Rows/Row[normalize-space(@Status)='In Progress'])" />
<xsl:variable name="CompleteCount" select="count(/dsQueryResponse/Rows/Row[normalize-space(@Status)='Complete'])" />

Later call these variables in your display <table> or <div> using CSS for styling and layout.  To show percentages divide the dvt_RowCount variable by the individual counts.  To show bars that adjust their height or width (vertical or horizontal) by the total then set the width of <div> tags by the variables as percentages.

Comments

Post a Comment

Popular posts from this blog

SharePoint Designer 2013 Approval Workflow with Comments

Image
Adding Comments to a SharePoint 2013 Approval Workflow I needed the ability to capture comments from Approval Tasks in a workflow.  This has changed greatly in 2013 workflows.  Everything is more modular and as such must be built somewhat from scratch.
SharePoint 2013 workflows can become corrupt.  This may have been fixed by a patch, but please refer to a previous post before creating any 2013 workflows in Designer: http://www.ericjochens.com/2014/12/sharepoint-2013-workflow-observations.htmlSharePoint 2013 does not have a built-in approval workflow, nor does a built-in task item include comments.  I solved this by building my own approval workflow, and using a custom content type to include a comments field.A SharePoint 2013 Workflow will not store the Task ID when a task is created, so you cannot do a lookup into that task list to grab comments or any other field.  I solved this by creating a separate workflow in the task list to read the Related Items column, and update the origin…
Read more

Change SharePoint server hostname and Web Application Names

Note: I realize that many admins are reluctant to delete web applications.  I personally know why I ma doing it and how to achieve this easily.  You should always retain any customization you have added to the site, like web.config mods, etc.  The Alternate Access Mappings are always available, but they leave open holes that I do not wish to keep active.  I like a clean setup.
Why? Perhaps you need to clone a development, test, or some SharePoint server and you need to change the hostname so that it can exist on the same domain without a SID conflict.  Or you just have a use-case for wanting to rename the hostname of a SharePoint server.  It can be done, just make sure you go through all of the steps.

The Rename-SPServer PowerShell command can also be used to change the SQL Server name, for the case where you might move the databases to a new SQL server or instance and you need to point all of the farm servers to this new hostname\instance.

Changing the hostname isn't that bad, bu…
Read more

The Timer Service Failed to Recycle

Image
SharePoint Timer Service Failed to Recycle In the Monitoring section of SharePoint Central Administration a Health Analyzer rule appears warning about:

The timer service failed to recycle.
Title The timer service failed to recycle. Severity 2 - Warning Category Performance Explanation
The last attempt to recycle the timer service failed as have most of the other attempts during the past week. Recycling typically fails because other timer jobs are running when the recycle is scheduled. To view which jobs blocked the recycle view the history for the recycle job and click on the failed status link for more information. The error message for the failed job entry will contain a list of jobs that were still running. Remedy
Change the schedule for the timer recycle job so that it does not conflict with other long-running timer jobs.
Failing Services
SPTimerService (SPTimerV4)
Environment SharePoint Server 2010 Enterprise
On-Premises
3 Web Servers, 3 Application Servers, 1 FAST Server, Acti…
Read more