Best Of

This just saved my butt.

@MichelleH has what I would have suggested, but she mistyped the character you are looking for. :)

Should be:

REPLACE(RIGHT(`Sent Email`,((LENGTH(`Sent Email`))-(INSTR(`Sent Email`,'@')))),'>','')

@Dheeraj_1996 then @MichelleH answer is what you're looking for. From the sample data you've provided, assuming you were running it on the 25th line 1 will return 12 and line 3 returns 5, so the difference would be 7.

If the idea is not to compare this to the current date, but be able to tell how many new files were received each day, then you'd need to use a window function instead, leveraging the LAG version (this will work since you've stated you have entries for every single day with no date gaps), it'd look something like:

COUNT(`local_collect_date_time`) - (LAG(COUNT(`local_collect_date_time`), 1) OVER( ORDER BY date(`local_collect_date_time`) ASC))

And you'd graph by local_collect_date_time grouping by day, with that you can get something that looks like:

Keep in mind that since this is a lag function, the first date in your date range will have no previous day information available, so the delta will be the start date.

Domo currently doesn't support filtering with window functions, so you're getting the error. They did previously but recently stopped supporting it without any reasoning or documentation.