Visual report Based on Data

vepp

Hello All,

I need some help from you in forming the below visual table report  to send it to customers on email.

Date of Report	No of Success	No of Failure
7/11/2021	2	1
SourceSystem	UserName	FolderName	ActualFileName	Status
A	Peter	C:	Max.csv	Success
B	John	😧	Min.csv	Success
C	Sctt	E:	Lux.csv	Failed

Date of Report	No of Success	No of Failure
8/11/2021	2	1
SourceSystem	UserName	FolderName	ActualFileName	Status
X	Peter	C:	Max.csv	Success
Y	John	😧	Min.csv	Success
Z	Sctt	E:	Lux.csv	Failed

My data is like this. 

Date of Report	SourceSystem	UserName	FolderName	ActualFileName	Status
11-Jul-20	A	Peter	C:	Max.csv	Success
11-Jul-20	B	John	😧	Min.csv	Success
11-Jul-20	C	Sctt	E:	Lux.csv	Failed
11-Aug-20	X	Peter	C:	Max.csv	Success

I was able to achieve in 2 separate table but I want in a one single report with multiple table. Please help me

DavidP

Hi @vepp,

I isolated the 11th July data from your example an produced the result below. Let me know if this works for you. 

You can use an email tool to email this object to your required audience.

visual report solution.yxmd