Hi Everyone,

There are some days where our data is affected by some external factors like a public holiday etc. I want to exclude data for certain dates so that it does not affect our Cost & Revenue models. How can I do that in media optimizer?

Thanks.





 
 Solved!
 
 [Go to Solution.](/t5/adobe-advertising-cloud/exclude-dates/m-p/163486#M257)
Hi Ishitaa,

Click on the portfolio settings and select the dates on the calendar from cost model and revenue model sections of campaign that you want to exclude and save to apply changes. If you click one time on the date/date range, the date will be selected with green color and excluded locally means from just that portfolio, if you click twice on that date/date range the date will be selected with blue color and will be excluded globally means from all portfolio in your account.

Hope it helps.

Regards

Nidhi




[View solution in original post](/t5/adobe-advertising-cloud/exclude-dates/m-p/163486#M257)
you should be able to set the element to not be visible on page load, and then on the conditional tab of the element, you should be able to construct a condition where parent group’s thing’s creation date < parent group’s thing’s modified date, this element is visible. and when i say “should be able… if you cancel your subscription, all of the data on it will be erased. you will need to contact our support team to see if they can adjust the billing date for you. since this is a community forum, we won’t be able to answer that question for you. [@najoua.abbaci](/u/najoua.abbaci)

mabye the flow can be adopted to following:

assign:

leftside: drresult (datatype: datarow)

right side:

dt\_datepv.asenumerable.orderby(function ( r ) datetime.parseexact(r(0).tostring.trim, “dd.mm.yyyy”, system.globalization.cultureinfo.currentuiculture.datetimeformat)).last()

so… hi,

unfortunately due to wordpress restrictions we couldn’t add a confirmation on plugin delete action if the user wants to keep existing tables and charts. previously we were just keeping those in db, but it caused problems when someone wanted to clean up the site and remove the plugin. we are sti… [@whyyouandi](/u/whyyouandi)

[image] whyyouandi:

i want to append another column of data.

you can add a column with [add data column] activity.

<https://www.uipath.com/activities-guide/add-data-column>

[image] whyyouandi:

and then edit the scrap date per row.

and to add a value to a target column, ch… You could go the easy way and use [ADO.NET Data Services](http://codebetter.com/blogs/david.hayden/archive/2008/01/08/getting-started-with-ado-net-data-services.aspx). [image] mbraun:

****** please disregard, i figured it out. there was a sort column in the data that was not being updated for some of values*** .

yep. if you would want to filter those out from the actual report you would do that in power query.

nick

[[enterprise%20dna%20expert%20-%20small]](https://enterprisedna.co/enterprise-dna-experts/) hmm.  you can use ticket rules to mute the ticket as soon as it gets created.  you can have it look for tickets from that particular email address and mute them as they come in. the atlassian community guidelines for vendors strongly discourages advertising/promoting apps. see <https://community.atlassian.com/t5/marketplace-apps-integrations/atlassian-community-guidelines-for-marketplace-vendors-and/ba-p/689723> for more details.

going direct to banning seems to be a bit str… > 
> i want to create ap application which generates popup alerts at the day of event ocurs as well as a day before the event will occur in a specific time interval as well.. events are stored in database and they are all date fields .. so i want to link those fields to create popups .. help me .
> 
> 
> 


In order to help you, you must first provide us with what you have achieved. We do not write code for you, simply correct and enlighten on mistakes.