Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
i goit a following situation, my table does look like:
Project | TimeOn | Typ | Budget |
A | 01.01.2018 | AA | 100 |
B | 31.12.2017 | BB | 150 |
C | 31.11.2017 | CC | 30 |
D | 31.09.2017 | CC | 60 |
and i use as timefilter, that i created on base of master calender the following filter:
Timefilter |
2017 11 |
2017 10 |
2017 09 |
2017 08 |
and i use the following set expression to calculate the budget for every typ of project:
Budget: | |
Sum({<Typ = {'AA'}>}Budget) | 100 |
Sum({<Typ = {'BB'}>}Budget) | 150 |
Sum({<Typ = {'CC'}>}Budget) | 90 |
everything does work great, now i have a question: lets imagine, my reportdate is:
2017 11 and if i select the date in Timefilter: 2017 11 , then should appear only two project:
Project | TimeOn | Typ | Budget |
A | 01.01.2018 | AA | 100 |
B | 31.12.2017 | BB | 150 |
because my timefilter-date: 2017 11 is lower then 01.01.2018 and 31.12.2017
and if select as reporting date 2017 10 then shoudl appear the following projects:
Project | TimeOn | Typ | Budget |
A | 01.01.2018 | AA | 100 |
B | 31.12.2017 | BB | 150 |
C | 31.11.2017 | CC | 30 |
because my timefilter-date: 2017 10 is lower then 01.01.2018, 31.12.2017 and 31.11.2017
Does have anybody any idea how to handle dynamic this issue with the helps of set expression?
Thanks a lot
Beck
Check this app. Please, install the extension to see full customization aplied.
Hi,
I'm missing something here, how you can you display projects with dates (01.01.2018 and 31.12.2017) when selecting the date 2017.11 ?
With the data set you mentioned above, I think you will only have the Project C displayed when selecting date 2017.01
Hi youssef,
first of all, thanks a lot for your responce:
the column TimeOn consists the Data as concluded Date of each project and the timefilter i have built on the base of master calender
can you describe more how you want it to be dynamic ?
try to describe the usecase.
maybe sthing like;
sum({<YearField=,MonthField=, TimeOn={">=$(=max(date(date#(Timefilter,'YYYY MM'),'YYYY.MM.DD')))"}>}Measure)
Hi youssef thanks a lot for your responce,
my usecase is:
if i select in timefilter the date: 2017 11 then shoul appear only two projects: A and B, because the Project A has 01.01.2018 and the Project B has 31.12.2017 in Column TimeOn.
2017 11 is lower then 01.01.2018 and 31.12.2017
Hi Omar,
thanks a lot for your responce, i will try to implement it and will report you
Hi Omar,
thanks a lot, i tried but it does not work, i think, i explained not enough clear, my customer says to me, we have only active projects, my table does look like;
Project | TimeOn | Typ | Budget |
A | 01.01.2018 | AA | 100 |
B | 31.12.2017 | BB | 150 |
C | 31.11.2017 | CC | 30 |
D | 31.09.2017 | CC | 60 |
if i select on my timefilter
30.11.2017 then i should see
Project | TimeOn | Typ | Budget |
A | 01.01.2018 | AA | 100 |
B | 31.12.2017 | BB | 150 |
my problem is, i should ask my customer, what does he mean with active projects and when i solved this question, i would like to know how to create the set expression with timeexpression, do you have any idea?
thanks a lot
Beck
Hey Beck,
Is this what you want to?
Cheers
Hi Thiago,
it does look good, do you have an example - qfv?
i make my selection in timefilter, do you have a dependence with timefilter?