query the database to generate a column chart

(0) Share

Report

Posted on by Antonioclk

Hi,

I have a Sharepoint list with this format

ID	Event	Argument
1	Login
2	Login
3	Search	Rome
4	Search	Paris
5	Search	Test

I want to make a column chart that will show the top 10 argument searched...

how can I do? I tried to use a with function but it doesn't work

ClearCollect(
 collAnalyticsSearches,
 With(
 { wSearch: Filter(db_Analytics,Event="Search") },
 GroupBy(db_Analytics,"Arguments","countSearches"),
 CountRows(countSearches)
 )
)

what am I doing wrong?

Thank you

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

developerAJ 4,763 on at

Like
a
(1)

Report
Copy link

Link copied!
@Antonioclk

Clear(collAnalyticsSearche); With( { wSearch:GroupBy(Filter(db_Analytics,Event="Search"),"Arguments","countSearches") }, ForAll(wSearch As s, Collect(collAnalyticsSearches, {Name:s.Argumens,count:CountRows(s.countSearches)}) ) )

use above formula

Please click Accept as solution and Thumbs Up. if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Antonioclk on at

Like
a
(1)

Report
Copy link

Link copied!

thanks