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.
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 .
Attached is an example. The code is in the Data Set computed column named "Quarters".