Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have one date field in my data.and some id,sales of data is there.
here if i select any date it has to go 7 days back for example
if i select 07/01/2005 it has to show 01/01/2015
same way if i select 01/01/2015 it has to show 25/12/2014 of data.
i have some ideas but those ideas are not giving proper result.
any ideas.
thanks in advance
May be this within your set analysis statement:
{<Date = {"$(=Date(Max(Date) - 7, 'YourDateFieldFormat'))"}>}
Where does it need to go back 7 days? In a chart? In a text box object? In script? Please provide more details for a better response.
Thanks,
Sunny
Hi it has to show in chart.
May be this within your set analysis statement:
{<Date = {"$(=Date(Max(Date) - 7, 'YourDateFieldFormat'))"}>}
Hi Mani,
Ya The above one will give the result
{<Date = {"$(=Date(Max(Date) - 7, 'YourDateFieldFormat'))"}>}