Home Analytics Designing reports
The community of Analytics developers are invited to follow and participate in the developer network.
OpenText technical experts collaborate with supported customers and partners in the Magellan product area.

how to create a computed Quarterly column from monthly column

Hi All,
I have a data set with a column that returns monthly date, ie 1st April, 1st May, 1st June but I want to show it by Q1 , Q2 etc
Is that possible if so how please, example will be very helpful.
thanks

Comments

  • I don't have time to create an example at the moment. My suggestion is to create a computed column in the data set. Add code to the computed column expression using the date column as the base value to be converted (row["your date column name"]). You should be able to find examples on the internet to convert dates or months to quarters.

    Jeff F.
    Customer Support Engineer I
    OpenText
  • Thanks Jeff I will search for the sample code and I am not sure what code to use .
    Regards

  • Attached is an example. The code is in the Data Set computed column named "Quarters".

    Jeff F.
    Customer Support Engineer I
    OpenText
  • Genius
    thanks

Sign In or Register to comment.