Profile Picture

Adding labels and columns for empty data

Posted By Thomas Link 9 Years Ago
Author
Message
Thomas Link
Posted 9 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: Forum Members
Last Active: 9 Years Ago
Posts: 2, Visits: 1

I have a combo chart that is showing stacked bar data by month and then overlays two line graphs.  All seems to be working just fine, except that I've been asked to list columns for months that don't have any data.  E.g. show all months January-December even if only March, April, May, and July have data so far. 

I've tried in vain to get this to work.  I managed to move the bars and add empty column spaces to the chart (using range -3 to 9) and I've managed to append the trailing month labels using C# and "scale.Labels.Add()" where scale is an  NScaleConfigurator object.  But I can't get labels into the preceding or intervening spaces where there is nothing reported (i.e., January, February, June).  Is there any way to do this (presumably in C#).  It seems that, once the chart is rendered, it is not possible to alter the label positions relative to the rendered data.

 

 



Nevron Support
Posted 9 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)

Group: Forum Members
Last Active: 12 hours ago
Posts: 2,994, Visits: 3,512
Hello Thomas,
Can you provide a snapshot of the data you pass to the Chart web part?

 



Best Regards,
Nevron Support Team



Thomas Link
Posted 9 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: Forum Members
Last Active: 9 Years Ago
Posts: 2, Visits: 1

I'm working with a SharePoint 2007 list.  I'm reporting on defects and their status and I have already sorted the list by project as a view .  I'm using 3 fields from the list to build my chart:  Status values (reported as Open or Closed on the chart) as two lines on the graph, Severity values which I'm reporting on as a stacked bar, and one category of Month (sorted ascending).

Months are from a DateTime field (Date_Discovered).

The Status entries can be any of the following (entries [] on the right are how I'm treating them as Open/Closed status in my current charts - also ignore the quotes):

 

"Assigned"                       [Open]

"Closed-Duplicate"            [Ignore]

"Closed-Rejected"             [Ignore]

"Monitor"                          [Open]

"Resolved"                        [Closed]

"Rework"                          [Open]

"Submitted"                      [Open]

"Tested-Verified"               [Closed]

 

The Severity listings include the number and can be any of the following (ignore the quotes):

 

"1-Critical"

"2-Very Important"

"2.5-Pretty Important"

"3-Important"

"4-Inconvenient"

"5-Minor"

"TBD"

 

Date_Discovered is a single DateTime selection: e.g., 8/1/2013

 

As I'm grouping some of the severities together (i.e. 1&2 and 4&5), I have two status values (value 0 and value 1) and five severity values (value 2-6).  I'm using the following formulas.  I set the display for values 0 and 1 to be "line' and values 2-6 as "bar" and "stacked"

 

      The formula that I used for "Closed" is:

 

      =SUM(LIKE(Fields!Status, "Resolved")) + SUM(LIKE(Fields!Status, "Tested-Verified"))

 

      For "Open" I use:

      =SUM(LIKE(Fields!Status, "Assigned")) + SUM(LIKE(Fields!Status, "Monitor")) + SUM(LIKE(Fields!Status, "Submitted"))

 

      For the Severity fields I used a variant of the above i.e.:

      =SUM(LIKE(Fields!Severity, "1-Critical")) + SUM(LIKE(Fields!Status, "2-Very Important"))

     

      I repeat this for the other four severity possibilities.

 

For Category 0 I'm using

 

Group By:

 =MONTH(FORMAT(Fields!Date_Discovered, "s")

 

Label:

 =FORMAT(Fields!Date_Discovered, "MMMM")

 

Sort:

 =MONTH(FORMAT(Fields!Date_Discovered, "s")

  - Set to Ascending

 

I'm making separate versions of the chart for each project and some start on different months than January and some have no records for certain months as mentioned in my first post. I've been asked to provide an empty labeled column for months that don't have any records.

 

I've tried attaching a sample of what I've got so far (this one is linear months with data for each moth to-date and doesn't have any missing months).

 

 

Thomas

 

 



Attachments
Nevron Chart Example.bmp (425 views, 560.00 KB)


Similar Topics


Reading This Topic