how to get date difference dynamically

[lakshman1031]

Hi All,

I have fields like  Metric1, Metric2, Metrc3, Metric4, Metric5 like that

Metric fields having values as date

Now i want to show the date difference using interval function

Interval(Metrc1-Metric2,'DD') using this expression we will get date difference in Days.

We will get static way, but we want to show dynamically.

Now i want to show data like I have two filters like all metrics created two inline table Metrics_Diff1, Metrcs_Diff2

Now i want to create bar chart in that i want to show date difference when i select two filters like

for example Metrics_Diff1 i have selected Metrc1 and Metrics_Diff2 i have selected Metric2.

Now in chart show dimension as Metric1 to Metric2 like that dynamically will change what ever user selection.

based on the selection we will show the date difference and we will restrict fields in interval function.

Can you please suggest me how to do achieve this scenario.

Thanks & Regards,

Lakshman