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