Adding Aggregated Numbers to Dashboard

[Ahmed_Zeidan]

Dear all, any way i can add summary numbers in the Dashboard, it seems in Dashboard i can only add charts, I appreciate any insights on this

[Aleksi]

I assume you want to have 4 views with these numbers on the Dashboard view. You can do that if you create 4 different detail views with these values.

[Ahmed_Zeidan]

Thanks Aleksi, would it be possible to provide example on this matter ?

[Koichi_Tsuji]

This is sample from my production app where I do have same tricks Alexki introduced to you.

[Ahmed_Zeidan]

Thanks a lot @tsuji_koichi, this is really great to see, I will test your solution accordingly

[Ahmed_Zeidan]

Dear @tsuji_koichi, would u help guide how to get the Details view to show 11 Calls for example ? what trick you are using to show 11 calls as the total number of calls ?

[Koichi_Tsuji · Accepted solution]

On one table, there is a column which will calculate the number (total) by appsheet expression.

Then create new virtual field, and push expression into app formula, such as [TotalCall]&" "&“Calls”, which will generate the strings.

Then add VC to header to the detail view then push into dashboard.

[Ahmed_Zeidan]

thanks for always helping @tsuji_koichi