Order Parameter

Question & Answer
,
1

Hello, good morning, I have a parameter that shows me ALL the orders created and I need it to show me in the drop-down list the orders that were created in the last 7 days. Any recommendation?

2

Hi @agustinmoncada94,

For this use case, you can create a calculated field at dataset level, that has the order values created in last 7 days. With every refresh of the dataset this list will get automatically updated. And this field can be used to configure the parameter.

Thanks,
Prantika

3

How would you create the field?

4

For this use case, how are you identifying when was the order created? If it is by a date field lets say order_created_date, then an example of the field will be

ifelse({order_created_date}>= addDateTime(-7,‘DD’, now()),order_id,NULL)

This has to be created at the dataset, not in the analysis.

5

Great, thank you very much.