66 reputation
213
bio website
location
age
visits member for 2 years, 3 months
seen Aug 26 at 2:14

EAI developer working mainly in Energy and Utilities, Health and Education sectors. Tools of my middleware trade have included webMethods, JavaCAPS, and I'm just about to get my hands dirty in some TIBCO.

Plenty of Oracle and MSSQL thrown about in integration/ETL anger too.

C#.Net is my weapon of choice for all things non-middleware (or at the SOA periphery, where OOTB APIs are non existent, or need a spruce up with something more web-servicey).

I have a history in infrastructure and applications support, which gives me a pretty good sense of the "bigger picture" in terms of how my code plays within the architecture of the wider technical environment, and in terms of how it should play with humans in the support/maintenance sphere when (heaven forbid) my code needs biological assistance.

More recently I've been dabbling in the world of the "front end" on my own time, so am finding my feet in web technologies such as CSS, JS, JQ etc. Am having fun developing (or supporting) sites based on open source CMSs such as WordPress, and learning PHP along the way.


Sep
24
awarded  Autobiographer
Jun
8
awarded  Notable Question
Feb
24
awarded  Popular Question
Jul
23
awarded  Notable Question
Feb
19
awarded  Popular Question
Feb
4
awarded  Popular Question
Oct
23
comment Create additional goal indicators on a KPI list
Thanks so much for your help. I wish I could accept more than 1 answer, as this was really helpful to me and was clearly an acceptable answer (I was able to implement it to meet the requirements of my question, with little fuss). But I went with the DataViewWebPart solution, because it seems more elegant (to me) to do the legwork on the server-side, rather than relying on client-side scripting. But not without quite a lot of internal debate, as your answer was the least complex solution that met my requirements. Thanks so much for your input, I do really appreciate your time and effort.
Oct
23
comment Create additional goal indicators on a KPI list
Thanks so much for your help, I really appreciate the input. At this stage we're just working with the one list, but if this changes, I'll be sure to look into this product.
Oct
23
comment Create additional goal indicators on a KPI list
Thanks so much for your help, I learned a lot as a result of your input. Wish I could accept more than 1 answer, as this was really helpful to me.
Oct
23
comment Create additional goal indicators on a KPI list
And the bounty goes to... @ghangas! I'm working through this now... haven't finished, but it seems clear to me that while it's a little more leg work (as I'm not proficient with XSLT at this stage), this is the way I should be doing this. Thanks again.
Oct
23
accepted Create additional goal indicators on a KPI list
Oct
22
comment Create additional goal indicators on a KPI list
This looks to me to be the "right" way to do what I'm trying to achieve, OOTB. I'll have a crack at this tomorrow and advise.
Oct
22
comment Create additional goal indicators on a KPI list
Also, say I'd use your lookup mechanism to select which image will be displayed for each of the 4 KPI thresholds (eg in future may have a number of different themed sets of icons from which to choose each status icon). But apparently I'm not able to use lookup values in the calculated column (where I need to check if the "score" column is over a certain "threshold" column, in order to select the correct status icon). Is there a suitable workaround that would make the lookup value available in the calculated column?
Oct
22
comment Create additional goal indicators on a KPI list
FYI had a look at this approach today, and it works and was straightforward, thanks. Am still going to explore the other answers here though, as Stef's adds a bit of "framework" around this approach (if I can get it to work), while @ghangas's looks like the "right" OOTB way to do it.
Oct
22
comment Create additional goal indicators on a KPI list
It seems I'm not (without significant red tape) able to add new web parts to the site, so instead I used a CEWP for the 'Text To HTML' component - which otherwise seems fine. But then the pictures.html file doesn't seem to be working for me; the image is not being rendered. I suspect the .js files are not being loaded. Is there any reason why I couldn't/shouldn't include that js in script tags within the pictures html, to keep it all self-contained (or are these .js files meant to be available in the SP build somewhere already)?
Oct
22
comment Create additional goal indicators on a KPI list
+1 Took me a while to understand what this offered above @Drew-Lanclos's answer (aside from your awesome instructions, thanks!). But now I get it! ;-)
Oct
22
comment Create additional goal indicators on a KPI list
+1 This looks like a very flexible solution, thanks! NB the johnsworkshop write-up is for 2010 - but there's a number of valuable links referenced there for 2007, eg msdn.microsoft.com/en-us/library/cc300164(v=office.12).aspx
Oct
22
comment Create additional goal indicators on a KPI list
+1 Thanks for the suggestion. Will explore this later today.
Oct
21
comment Create additional goal indicators on a KPI list
+1 This looks promising, thanks. I've asked the powers-that-be if they're willing to run a 3rd party control.
Oct
21
comment Create additional goal indicators on a KPI list
@HughWood At this stage, it is 2007 I'm afraid. But it may be that we can hold off on this until 2010+ is available. Thanks for your input.