4 Replies Latest reply on Aug 4, 2016 1:45 AM by Mark Fraser

How to create a group of months?

Dilyana Suleymanova Aug 4, 2016 12:41 AM

HI there,

I would like to create a group of months from 12.2012 till 03.2016. From April every months should me shown as individueal. EXample:

Start value

12.15-03.16 04.16 05.16 06.16 07.16

Does anybody have done an expierience with this?

Thank you in advance!

Best

Dilyana

1. Re: How to create a group of months?

Mark Fraser Aug 4, 2016 12:58 AM (in response to Dilyana Suleymanova)

Hi Dilyana

You could just use an IF statement... something like (this is just for the concept...)

IF [date/time] < Apr-16 Then '12.15-03.16'
ELSE [date/time]
END

You may need to do some formatting and date manipulation using DATEPART() but should be easy enough.
Is that enough to get you started?

Happy to help further, although some example data would help.

Cheers
Mark
Like Show 0 Likes(0)

Actions
2. Re: How to create a group of months?

Mark Fraser Aug 4, 2016 1:06 AM (in response to Mark Fraser)
Something like this?

Book1.xlsx 8.0 KB
Like Show 0 Likes(0)

Actions
3. Re: How to create a group of months?

Dilyana Suleymanova Aug 4, 2016 1:36 AM (in response to Mark Fraser)

It is great! Thank you Mark
Best regards from Berlin!
Like Show 2 Likes(2)

Actions
4. Re: How to create a group of months?

Mark Fraser Aug 4, 2016 1:45 AM (in response to Dilyana Suleymanova)

You're welcome, neighbor...!
Best regards from The Netherlands
Like Show 1 Likes(1)

Actions

Tableau Community Forums