Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This was an issue with the way you created your year and Season field in the script... made the changes and check now
May be like attached
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
This was an issue with the way you created your year and Season field in the script... made the changes and check now
Thank you Great Work
Thank you