topic Re: How to show data for only the most recent week? in App Development

How to show data for only the most recent week?

Mch201 — Sat, 16 Nov 2024 17:31:50 GMT

I have a bar chart with data that is updated every week. how can i make it that it only shows data for the most recent week without using filter every time?

Re: How to show data for only the most recent week?

mfchmielowski — Wed, 03 Feb 2021 16:00:36 GMT

Hi.

You can use SetAnalisys expresion fe. sum({< yourDateCol={">=$(=WeekStart(today(1)))"} >} productQuantity)

Re: How to show data for only the most recent week?

Mch201 — Wed, 03 Feb 2021 18:34:04 GMT

Hey, thanks for the response. can you tell me why this is giving me an "invalid dimension" error? Week is the column which has the week number in it.

**hid the dimension for privacy reasons

Re: How to show data for only the most recent week?

Ksrinivasan — Wed, 03 Feb 2021 18:53:38 GMT

hi,

you can create variable= vMaxweek=Max(Weekno)

then call in chart measure as

Sum({$<Weekno= {'$(=vMaxweek)'}>}sales)

ksrinivasan

Re: How to show data for only the most recent week?

mfchmielowski — Wed, 03 Feb 2021 21:04:32 GMT

Hi.

WeekStart(today(1)) returns Date not numer of week. Check this: sum({ < Week={">=$(=Week(today(1)))" >} columnName)

The Ksrinivasans looks also correct.

Re: How to show data for only the most recent week?

Mch201 — Wed, 03 Feb 2021 21:10:18 GMT

This expression will go under my measure, correct? & "sales" is a measure in your example ??

Re: How to show data for only the most recent week?

Mch201 — Wed, 03 Feb 2021 21:25:19 GMT

Where exactly will this go?