Create report from SQL: from raw data to summarized info

[HensRansen]

Hi,
all of our robots put the outcomes of their transactions into 1 database table, like this:

|Procesnumber|Date|Outcome|
|1|1-1-2024|Succesful|
|1|2-1-2024|Bus Exception|
|2|1-1-2024|Succesful|
|2|1-1-2024|Succesful|
|2|1-1-2024|Sys Exception|
|2|2-1-2024|Bus Exception|
|2|2-1-2024|Bus Exception|
|2|3-1-2024|Bus Exception|
|3|1-1-2024|Succesful|
|3|1-1-2024|Succesful|
|3|1-1-2024|Succesful|
|3|2-1-2024|Succesful|
|3|2-1-2024|Succesful|
|3|3-1-2024|Succesful|
|4|1-1-2024|Bus Exception|
|4|1-1-2024|Succesful|
|4|2-1-2024|Succesful|
|4|2-1-2024|Sys Exception|

So every transaction has an entry.

Everyday, I want to send an email containing this information:

I know how to query a database, to get the individual transactions (select from where :))

But where (sql or UiPath or…) do I summarize and make percentages of them? What are the best design choices?

And mayby I only want to show the processes with a higer than usual error %. But that requires the same data.

Thanks!!

[ppr (Peter Preuss)]

In general it is about Grouping The data

@HensRansen

But where (sql or UiPath or…)

whatever we can do in SQL on Database Data we would work as close as possible at the source
When implementing it in UiPath, LINQ can support us
[HowTo] LINQ (VB.Net) Learning Catalogue - Help / Something Else - UiPath Community Forum

[HensRansen]

wow, that is a very cool post/tutorial collection!
Going to look into it!