Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI Experts
Please help me with the below....please.
I need to create a from date and to date calendar in my sheet. and it has to select the dates from one column in my excel named 'created date.'
Please help.
Hi @tenyeapen ,
Create 2 variables for from date and to date in Setting->Variable Overview->Add ,
vFromDate= yourDateField
vToDate = yourDateField
Create 2 calendar objects, 1st for from date,
and 2nd for to date same like above.
Regards
Hi Boss
I created like above said and the date also showing. But the data on sheet not changing according to from and to dates.
For eg :
=Sum({<createdDate={">=$(=vFromDate)<=$(=vToDate)"}>}sale)
Hi @tenyeapen ,
Hoping that you are not doing any aggregation, I think it is direct data you want to show and hope you are using date as dimension.
createdDate, invoice number, revenue, sales person, created date
Dimension : createdDate Expression for invoice number : = if(createdDate>=vFromDate and createdDate<=vToDate,[invoice number]) Expression for revenue : = if(createdDate>=vFromDate and createdDate<=vToDate,revenue) ...........
Do the same for all columns, data will get filter.