topic Re: Weekday in set analysis in App Development

Weekday in set analysis

pascaldijkshoor — Thu, 15 Mar 2018 13:51:46 GMT

Hello,

I want to include certain weekdays in set analysis. For example that it only shows data for monday. These are the formulas i have tried, but both don't work:

Count ({$<weekday={"Ma"}>}LOAD_INDEX)

Count ({$<weekday(L_begin_date.date)={"Ma"}>}LOAD_INDEX)

Making a filter with weekdays is not an option for me.

Thanks in advance

Re: Weekday in set analysis

sunny_talwar — Thu, 15 Mar 2018 13:53:20 GMT

Do you have a field called weekday in your application? What format does it have?

Re: Weekday in set analysis

pascaldijkshoor — Thu, 15 Mar 2018 14:14:28 GMT

I don't have a field called weekday in my dataset. I have tried to add calculated field in the data manger, but there is no weekday function in the data manager.

Normally when i want to use weekday as a dimension i use the formula: =weekday (L_begin_date.date)

Re: Weekday in set analysis

sunny_talwar — Thu, 15 Mar 2018 14:30:22 GMT

Try this

Count({$<L_begin_date.date = {"=WeekDay(L_begin_date.date) = 'Ma'}>} LOAD_INDEX)

Re: Weekday in set analysis

pascaldijkshoor — Thu, 15 Mar 2018 15:45:53 GMT

When i enter this i get an error

Re: Weekday in set analysis

sunny_talwar — Thu, 15 Mar 2018 15:48:19 GMT

My bad, I missed the ending double quote... try this

Count({$<L_begin_date.date = {"=WeekDay(L_begin_date.date) = 'Ma'"}>} LOAD_INDEX)

Re: Weekday in set analysis

Nagaraju_KCS — Thu, 15 Mar 2018 15:58:12 GMT

One option,

Create back end weekday (L_begin_date.date) as Weekday.

Simply use your expression

Count ({$<Weekday={"Ma"}>}LOAD_INDEX)

Re: Weekday in set analysis

pascaldijkshoor — Thu, 15 Mar 2018 16:02:07 GMT

Then i only get 0 as values. Thanks for your replies anyway

Re: Weekday in set analysis

pascaldijkshoor — Thu, 15 Mar 2018 16:03:17 GMT

Do you mean to add this line in the load editor?

Re: Weekday in set analysis

sunny_talwar — Thu, 15 Mar 2018 16:06:44 GMT

May be try with the number

Count({$<L_begin_date.date = {"=WeekDay(L_begin_date.date) = 1"}>} LOAD_INDEX)

I used 1, but not sure what weekday Monday is for you... replace 1 with whatever it is

Re: Weekday in set analysis

Nagaraju_KCS — Thu, 15 Mar 2018 16:16:52 GMT

Create derived column in the load editor, like below

Load L_begin_date.date

Weekday(L_begin_date.date) as WeekDay // Derived column

From table;

Re: Weekday in set analysis

Nagaraju_KCS — Thu, 15 Mar 2018 16:17:43 GMT

would you be able to send sample code??

Re: Weekday in set analysis

pascaldijkshoor — Fri, 16 Mar 2018 14:14:52 GMT

This works, thank you!