Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a date filed as Date which has data from 2001 to till date ..
this field iam using it in the Dimesnion .
I want to show only 2 years data like ( from jan-2015 , Feb-2015.....till date )
How should i achieve this .
What is data format in this field and you need this in load script or UI let me know.
in calculated dimension
=if(Match(Year(Date),2015,2016),Year,Null())
and tick suppress when value null
Hi Anand
The date format is
01-01-2017 00:12:22
For which two year data you need last 2 years or it is hardcoded.
my date format is
Could you please share some sample file?
or try like this in your back end
date(floor(timestamp#(date,'DD/MM/YYYY hh:mm:ss'))) as Date,
Year(date(floor(timestamp#(date,'DD/MM/YYYY hh:mm:ss')))) as Year
I want to show this like this
Hi john,
You want to start by Creating a master calendar. this will allow you then create a month year field to display as you have requested. look at the link below.
Your Dimension would be MonthYear and then in your set analysis would contain {<Year={'>2014'}>}.
Mark
For this use this Dimension and Metrics expression.
Dim :- =MonthName(Date)
Expre:- =sum({<Date={">=$(=Date(AddMonths(Max(Date)-24)))"} >} MetricsField)
Ex:- =Sum( {<Date={">=$(=Date(AddMonths(Max(Date)-24)))"} >} Sales )