Want to filter records in dataset for past 3 weeks using scenario

---

@Ruta
wrote:

On output dataset (CSV file) how can I apply filter to fetch only last 3 weeks records and send a email on every weekend.

Hi have asked this question already in your other post and I have provided the following answer:

"Mail dataset attachments can't have any filters applied to them. But this is a trivial problem to bypass. Just add a new Filter recipe using your original calculate percentage of 0s dataset as an input and then set whatever filters you want. Then use the new output dataset in your mail attachment."

Is there a reason as to why you are not able to do the steps I suggested?

---

@Ruta
wrote:

I need to also highlight records within dataset with warning if the error column value is > 90.

Do I need to write python recipe for it or their is some other way to do it?

---

You don't need to use Python. Have a look at the Dataset conditional formatting documentation which is available in v12.5 or above. The format should be preserved with you export the dataset to Excel.

>> Yeah I agree dataset attachments can't have any filters applied to them.

Apply the filter to a new dataset using the previous one as input. Then use this new dataset as the mail attachment.

>> I am using Dataiku 12.1 version

As I said the "Conditional formatting" feature is available in Dataiku v12.5 or above. If you have v12.1 then it is obviously NOT available. Upgrade your Dataiku version if you want this feaure.