topic Re: Measure for the week only in App Development

Measure for the week only

jerryr125 — Sun, 09 Jun 2019 13:59:56 GMT

Hi -

I have two fields I am focusing on - Date and Amount.

The Date 'data' has all of the autocalendar features.

How do I set it to where if a specific date range is selected, it can display the Amount ONLY for all of the dates in that week ?

Example - if one date is selected in that week, it shows a total of the Amount for the entire week and NOT just that date.

Thanks - Jerry

Re: Measure for the week only

Vegar — Sun, 09 Jun 2019 20:55:31 GMT

Try something like this:
Sum({<Date, YearWeek={'$(=WeekName(max(Date)))'}
>}Amount)

Or maybe this:

Sum({<Date= {">=$(=weekstart(MIN(Date)))<=$(=weekend(MAX(Date)))"}
>}Amount)

Re: Measure for the week only

bing_jville — Sun, 09 Jun 2019 20:53:25 GMT

How about change the date field used in the date filter to

Dual(date, YearWeek)

Re: Measure for the week only

Channa — Mon, 10 Jun 2019 01:22:13 GMT

week(date) it will bring week from select date

Sum({<Date=, Week={'$(=week(Date))'}>}Amount)

u can pass selected date into variable

vWeek=week(Date)

Sum({<Date=, Week={'$(vWeek)'}>}Amount)

Re: Measure for the week only

Vegar — Mon, 10 Jun 2019 05:04:24 GMT

@Channa Week() will only gives you the week number, if your data runs over multiple years you will need to use a column using both weeknumber and year like weekname().

Re: Measure for the week only

jonathandienst — Mon, 10 Jun 2019 06:04:08 GMT

And the variable vWeek will only work with a date selected. Use Vegar's suggestions above.

Re: Measure for the week only

jerryr125 — Mon, 10 Jun 2019 13:50:53 GMT

Hi - this seemed to do the trick :

Sum({<Date=, Week={'$(=week(Date))'}>}Amount)

Thank you - Jerry