Applying possible selections of a field to another field

[lavanya14]

Hi All,

I have a timestamp field1 (format 26/07/2018 01,26/07/2018 02 etc) also I have got another field2. I need to apply the selected values (lets say if 10 values are selected ) of field1 to field2 in set analysis.Filed1 and field 2 are from different tables joined with date.

Any suggestions are appreciated.

Thanks in advance.

[YoussefBelloum]

Hi,

here is a set analysis example you can try to apply

{<Field2={"$(=Concat(distinct Field1))"}>}

PS: make sure that both fields are on the same timestamp format

[Anil_Babu_Samineni]

Not really sure, If i understand correctly, But perhaps this?

Sum({<Date1 = {"=Date1 = Date2"}>} Sales)

Or

Sum(If(Date1=Date2, Sales))

[sunny_talwar]

May be this

{<Field2 = p(Field1)>}

[balabhaskarqlik]

May be this:

=num(avg({1<Field1={'$(=getfieldselections(Field2))'}>} Sales),'0.00')

=Sum({1<Field1={'$(=getfieldselections(Field2))'}>} Sales).

[Anonymous]

Lavanya,

Can you provide sample data\App?

[lavanya14]

Hi All,

Many thanks for your reply. I am still working on this. Will update you all soon.

Thanks again.

[lavanya14]

Hi All,

Can some one suggest me how to select set of field values of Field 1(timestamp) in Field2.(day)

Let's say I have the timestampvalue (dd/mm/yyyy hh) in Field1 and if the values selected in Field1 are 29/07/2018 00 to 31/07/2018 09. so I need to select the days in field 2 which are 29,30 and 31. Field1 and field2 are in different tables. I would like to make this selection in via button trigger.

Any suggestions are much appreciated.

Thanks in advance.

[Anil_Babu_Samineni]

Not really sure - What your request. Would you like to share work file which is faster than slower response ..

[lavanya14]

Hi Anil,

Thanks for replying. Please find the sample data attached.