email tool with multiple count fields

[Aryanaj]

My report tracks the data daily. Can you please tell me how to show new data (table format) on the email body with its count and overall count. 

Basically, how to show three (today's count, total count, and the table) fields on the email body.

Also, I want to send a single email which accommodates all the rows with today's date,

Sample workflow attached.

I am a beginner. Thanks in advance.

[MichaelSu · Accepted solution]

Hi @Aryanaj ,

Take a look at the attached workflow. Because you didn't package your data with the workflow (Options -> Export Workflow) we were not able to see the input data. I just threw some made up data that I had in there. 

What we did in this case was used today's count and total count as the header and then added the table to the body of the email. I know this isn't exactly how you intended but hope that it gets the job done?

Thanks,

Mike

[Aryanaj]

Thanks @MichaelSu 

Apologies for the incorrect workflow,

Your solution works for me. Looks good.

Thanks a lot.

[MichaelSu]

Of course! Also, if you wanted to include the current date, you could add a datetimenow tool and add it to that join multiple. See attached if interested.

[Aryanaj]

Thanks @MichaelSu  for the tip

I added the condition in Filter Tool previously, but datetimenow tool works too.