Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I need some help to show data in a graph which only shows the months for the current quarter
I.e. QU1 = Apr - June
QU2 - Jul - Sept
QU3 - Oct - Dec
QU4 - Jan - Mar
I have a field (See below) which show all the months of the year but I want my chart to just show the months for the current quarter
CWT_Monthly_desc.desc_month_Year
Can anyone show me how I get this to show in a bar chart?
Kind Regards
Helen
Try this calculated dimension: =if(InQuarter( CWT_Monthly_desc.desc_month_Year, Today(),0), date(CWT_Monthly_desc.desc_month_Year,'MMM YYYY'))
This won't show anything in the qvw you posted since the current quarter is now 3 and your document doesn't contain data for this quarter. If you update your document with data for this quarter the chart should show the data of the current quarter. You can try it out anyway by changing the offset from 0 to -1 so that it shows the data of the previous quarter: =if(InQuarter( CWT_Monthly_desc.desc_month_Year, Today(),-1), date(CWT_Monthly_desc.desc_month_Year,'MMM YYYY')). See attached qvw.
Hi,
could u please post a sample file...
Hello
Thank you for any help in advance
Please find attached a QVW which shows a graph which is showing data from Apr 2012 - June 2013
However what I want to do is map the quarters map to the field called:
CWT_Monthly_desc.Month |
so that I can get a link between the quarters map and the dataset
What I then want is for the graph to only ever show the current quarter - At the moment the current Quarter is showing for each month
(I have attached file to my original question)
Are you able to provide any assistance?
Thanks
Helen
Hello
Thank you for this, I think this is a useful thing to know
However when I use this I get Quarter 1,2,3 and 4 showing. What I would like to show is the months for the Current Quarter
I.e. at the moment the max quarter is 2 and I would ideally like to show the month July - Sept along the X axis of my graph
Are you able to help?
Thanks
Helen
here maybe try this in your dimension of your chart:
=if(mod(ceil(Month(QuarterStart(CWT_Monthly_desc.desc_month_Year))/3)-2,4)+1 = Current_Quarter, date(CWT_Monthly_desc.desc_month_Year,'MMM YYYY'))
Then check the box supress when value is null. This will only show the months for the current quarter 2.
You could do as mohit did and do it in loadscript:
mod(ceil(Month(QuarterStart(DATEFIELD))/3)-2,4)+1 as QuarterNum
Then maybe in dimension:
if(QuarterNum = Current_Quarter, date(CWT_Monthly_desc.desc_month_Year,'MMM YYYY'))
and check the box supress when value is null.
Hope this helps.
Note:
mod(ceil(Month(QuarterStart(CWT_Monthly_desc.desc_month_Year))/3)-2,4)+1 does the same thing as mohit's formula above except without the 'QU'.
Try this calculated dimension: =if(InQuarter( CWT_Monthly_desc.desc_month_Year, Today(),0), date(CWT_Monthly_desc.desc_month_Year,'MMM YYYY'))
This won't show anything in the qvw you posted since the current quarter is now 3 and your document doesn't contain data for this quarter. If you update your document with data for this quarter the chart should show the data of the current quarter. You can try it out anyway by changing the offset from 0 to -1 so that it shows the data of the previous quarter: =if(InQuarter( CWT_Monthly_desc.desc_month_Year, Today(),-1), date(CWT_Monthly_desc.desc_month_Year,'MMM YYYY')). See attached qvw.
Thanks so much for your Help, this has really helped
Sorry to be a pain, but If I were to load in July data and the calculated dimension has Today()-1). How could I get the calculated dimension to change to Today(),0)?
Thanks for any help in advance
Thanks
Helen