Return field from one calculated in chart

[mgomezlor]

Hello,

I have a simple table with the program field, the date and the difference in months between the date of each program and the date filtered in the reporting end date. On the other hand I have an inline that returns, depending on the difference in months calculated in the table, its time factor.

I need to take the time factor for each program and I have tried with only ({<N_MONTHS = {$ (vDifDates)}>} N_TIME_FACTOR) and IF but it does not return the Time Factor corresponding to each program.



This is the table that should exit for Reporting End Date without any filtered date (today by default)

PROGRAM	DATE	Dif date	Time Factor
P1	2015-01-01	37	3
P2	2015-07-21	30	3
P3	2015-12-25	25	3
P4	2016-06-18	20	3
P5	2017-03-15	11	2
P6	2017-04-10	10	2
P7	2018-10-31	-9	0
P8	2018-11-04	-9	0

Thank you very much in advance.

[zebhashmi]

I think you need to use apply map in script

[mgomezlor]

That is not valid because I need the difference between the dates depending on the user selection in filter reporting end date

[zebhashmi]

something like that

I am trying to change 4 as column value but it is giving me error try on your own

=FieldValue('N_TIME_FACTOR',fieldindex('N_MONTHS','4'))

[JustinDallas]

I'm confused about your goal.

[Digvijay_Singh]

Your Island table(having N_MONTHS) and PROGRAM table are not associated in data model so I think it is not possible to Time factor in your current chart. On what basis chart dimensions (PROGRAM,DATE) will link to the values of Time factor/N_MONTHS without any association.

You may need to think of change in data model.

Histalwar1‌ , Do you think its possible to show columns from un-associated table thru set analysis, could be a new learning for me if its possible.

[sunny_talwar · Accepted solution]

Set analysis isn't going to work... but if can...

Sum(If(N_MONTHS = $(vDifDates), N_TIME_FACTOR))

[mgomezlor]

That´s perfect !!.Thank you Sunny Talwar

[Digvijay_Singh]

Great!

[zebhashmi]

wow