Skip to Content
0

How can i filter for the Last complete 12 months

Apr 12 at 09:53 PM

47

avatar image

i have a run chart the data for which is updated weekly. When i 'review the chart I want to show only the last 12 consecutive complete months. I need to automate the field but current cant do without manual intervention.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Apr 12 at 10:03 PM
0

Hello Tony - if your data source is a BEx query, I would use the standard BEx variables that come with the Query Designer - e.g. last year, last 12 months, etc. Your application will be much faster too as it will process on the backend.

If your backend isn’t BEx, what is it? Also which version/SP of Lumira are you using?

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Sorry Tammy, I misread the point about accepting the comment. I'm still can not resolve this issue and it seems there should be a simple answer.

0
Tony Smith

Hi Tony - I am not sure if that will work with those data sources...I am not sure how to automate. Sorry

0
Tammy Powlas

Ok thanks for responding. I will keep looking :)

0
Tony Smith 6 days ago
0

hi Tammy I'm not sure what a BEx query is. I'm using an excell spreadsheet as a datasource and I have both lumria 1.3 and lumria discovery 2.0 applications to manage.

Share
10 |10000 characters needed characters left characters exceeded