Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to see only past 10 weeks data in Line chart. Week format is like DD/WW/YYYY.
KIndly hlep.
Hi
You need to extract the weekname from the format and then restrict the dimension to show only past 10 weeks data.
Can you share some sample data to work upon?
If i understood correct, below code should work
Script:-
T:LOAD * INLINE [
Date
7/1/2018
14/2/2018
21/3/2018
];
F:
load Date, SubField(Date,'/',2) as Week
Resident T;
drop table T;
Now just use calculated dimension in which Week is less than or equal to 10, and use your expression.
Hi,
In a same year its working fine, but for last year and all the week number is not able to compare.
Okie, you need to put condition for Year too. Can you share sample data?