ProductsAI & Analytics

Last Week in the Forums: Setting the Marker Range Border Color in Script, Aggregating Data

This blog series takes a look back at the past week in the forums, recalling how active they were and highlights some of the questions asked that seem to frequent the forums or other interesting topics. The forums remain very busy as we reach the end of the first third of the year. As always, thanks to those users who help answer questions! It is a great help to the community!

The unanswered post, from last week, that we’ll cover is about setting the color of the marker range border, in script. The poster is setting a marker in their gantt chart, in script, but when they set the color, the border line doesn’t change. They’re wanting to change the border color and width. If anyone has code that will allow them to do this, please post in the thread.

The next post I’ll cover this week is about creating start and end date fields for a given ID, from a single date column. The poster had data like:

ID,absent,date
11,oui,12/02/2012
11,oui,13/02/2012
11,oui,14/02/2012
11,oui,15/02/2012
22,oui,12,02/2012
22,oui,13/02/2012
22,oui,14/02/2012

and wanted to get:

ID,absent,startDate,endDate
11,oui,12/02/2012,15/02/2012
22,oui,12/02/2012,14/02/2012

A query solution is offered in the thread that helped them achieve this. It can be seen in the thread.

The last topic I’ll cover today, is about finding the difference between two rows. A link to a past forum post was posted in the thread that has a script solution to this type of issue. Take a look.

Again, this is just a small sample of what went through the forums this past week. For more questions and answers that have been posted, check out the forums. As always, if you have a question, feel free to ask it, and if you see a question you know the answer to or have a similar experience to, feel free to post an answer or comment. 

Show More

OpenText

OpenText is the leader in Enterprise Information Management (EIM). Our EIM products enable businesses to grow faster, lower operational costs, and reduce information governance and security risks by improving business insight, impact and process speed.

Related Posts

Back to top button
Close