Prompt with default current date and show the data for past one month

[former_member215240]

Hi ,

I have a Creation date field in Webi report. Whenever user executes the reports the field creation date should take current date and gives output for past one month. Could anyone suggest how to achieve this in Webi report or in Universe.

Thanks and Regards

Santhosh

[former_member215240]

Sure Thank you

[former_member182342]

Hi Santosh,

Pass the current date as a default parameter or create constant value as Current date filter in universe so it will show Creation date as current date.

And to show for last month data , Create predefined filter at universe level and use the same filter at Report Level so report will bring last month data.

Thanks,

Anish