INLINE VARIABLE FORMULA

[#1]

How to create a variable with calculated formula like

LOAD * INLINE[

SET VAR1=DATE(2)-DATE(1), SET VAR2=DATE(3)-DATE(2),SET VAR3=DATE(4)-DATE(3)

AS $(FIELD1)

];

Can we use the field1 as one dimension in x-axis of the bar chart where y-axis will be average no of days?

Thanks

[#2]

hi

on your dashboard.

press CTRL+ALT+V

then clik on Add, write var1, then select var1, go to definition write =DATE(2)-DATE(1).

similarlly make another variable.

then on bar chart --

dimension--> field1

Expression--> $(var1)

[nilesh_gangurde]

Please find attachment.

-Nilesh