Count ColumnChart

(0) Share

Report

Posted on by MiniMax92

151

Hey ho,

i need a "ColumnChart" with singel datas.

My formular is:

CountA( Table( Distinct(SharepointList;Location)))

But it is underline in Red with failure massage: "Table Value needed"

Heeelp :D

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

D_D 107 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

do you try to use the Formula as your Items of the Column Chart?
CountA returns a number, but you need to pass a table as items. This is what the failure message says.
You can try Items = Table(Distinct(SharepointList;Location)) and view the resulting chart.

--------------------------------------------------------------------------------------
If this helps you or solved your question, please like or mark this as an answer.
Best regards, David

Was this reply helpful? Yes No
MiniMax92 151 on at

Like
a
(0)

Report
Copy link

Link copied!

Thx for your reply,

i try it but now I no longer have an error message, but no columns are displayed. Although there is data in the column. The aim is to count how many are in Location 1 and how many are in Location 2 and so on. And Distinct filters the same locations, that works great too but somehow it doesn't count them.

As you can see in the picture, the names also overlap with each other.

Was this reply helpful? Yes No
AhmedSalih 6,680 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hello, Distinct function return a table with one column. Have you tried to use only the distinct function with the Table function?

CountA(Distinct(SharepointList;Location))

Was this reply helpful? Yes No
MiniMax92 151 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey,
Yes. The Formular is in Items and your Formular is the same result with no Chart :(

Was this reply helpful? Yes No