how to create a computed Quarterly column from monthly column

hatra
edited February 11, 2022 in Analytics #1

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.

    Warning No formatter is installed for the format ipb
  • 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".

    Warning No formatter is installed for the format ipb
  • Genius
    thanks