How Can I show my data for fixed 6 month (by season)

[Anonymous]

Hello All

I need a report for fixed 6 month(by season -SS or FW)

My data consists of  UniqueID and Transaction Date.

MyData:

LOAD * INLINE [ UniqueID,Transactiondate

1,01/02/2017

2,01/03/2017

3,01/04/2017

4,01/10/2017

5,01/12/2017

6,02/04/2017

7,02/04/2017

8,02/17/2017

.........

];

I have also created Dates; that maps the Transactindate to

Month,Year,Month Name,Quarter,Season...

Dates:

add Load Distinct

Transactiondate,

Month(Transactiondate) as [Month],

Year(Transactiondate) as [Year],

MonthName(Transactiondate) as [Month Name],

num(Month(Transactiondate)) as [Month No],

'Q' & Ceil(Month(Transactiondate)/3) as Quarter,

        if(Month(Transactiondate) >=2 and Month(Transactiondate) <= 7, 'SS', 'FW') as Season

Resident MyData

order by Transactiondate Asc;

Find full data and code in attached text file: fullData.txt

Note that the Season 'SS' (spring-Summer) is from February to July inclusive

while Season 'FW' (Fall-winter) is the remaining month.

I have multiple listboxes which allow users to make date related selections.

But for this problem I want the graph to show the count of transaction per season/Year.

Regardless of what month or Day selected the Graph should always show the season and year selected data.

By default if the if no Season or year is selected the graph can display the relevant  info for current Date(today) but not a major problem if not doable.

The info shown should always be in 6 month range:

SS - February to July of current year

FW - August to December of current year and January of Year +1

I have also included the QVW file if that helps

Thank you all in advance

any hint or advise is greatly appreciated

[sunny_talwar]

May be like attached

[Anonymous]

Dear Sunny

Thank you for all your feedback and help.

One small issue regarding the case above - When FW is selected the January must come form the CurrentYear +1

it is taking the January of the Currentyear.

Is there a way to solve that issue

thank you again

[sunny_talwar · Accepted solution]

This was an issue with the way you created your year and Season field in the script... made the changes and check now

[Anonymous]

Thank you Great Work

[sunny_talwar]

Thank you