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
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.
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".
Genius thanks