SAC Application Design - date range filtering

Former Member · ‎2020 Feb 20

Hello!

My question is very similar to this: SAC show two date periods using 1 date (story or page) filter and I was able to do so by using the date ranges filter on the restricted measures. My issue now is how would that happen if I'm gonna do it on application designer? I noticed that in the application designer, the date ranges filter is set to the current system date. My goal is to have the date be set by the user (custom input). I'm thinking of using the timerange function but I don't think that it will solve the problem.

Any help is appreciated. Thank you!

Alex_B · ‎2022 Feb 13

Hi forest_green,

I stumbled over your question. I was also searching for a date input possibility in application designer. Now I got one. It's not the fanciest but maybe it helps you too.

I created two Input Fields for the start and the end of the time range and a button for the execution.

Code of Button "Set period":

var date_start = InputField_start.getValue();
var date_end = InputField_end.getValue();
var day_start = ConvertUtils.stringToInteger(date_start.substring(0,3));
var day_end = ConvertUtils.stringToInteger(date_end.substring(0,3));
var month_start = ConvertUtils.stringToInteger(date_start.substring(3,6));
var month_end = ConvertUtils.stringToInteger(date_end.substring(3,6));
//in javascript month starts with 0 not 1, so you have to do -1
var month_start_conv = month_start-1;
var month_end_conv = month_end-1;
var year_start = ConvertUtils.stringToInteger(date_start.substring(6,10));
var year_end = ConvertUtils.stringToInteger(date_end.substring(6,10));
var range = TimeRange.create(TimeRangeGranularity.Day, new Date(year_start,month_start_conv,day_start),new Date(year_end,month_end_conv,day_end));
console.log(range);
Chart_1.getDataSource().setDimensionFilter("0CALDAY",range);

SAC Application Design - date range filtering

Know the answer?

Need more details?