Hello everyone,
I’m having an issue with my AppSheet dashboard.
I created a Card View to display my KPIs (for example: Absent Rate, Attendance %, etc.), but in the dashboard, only the KPI names appear — the values don’t show up.
Here’s what I checked:
The [KPI_Value] column in my table shows 0 in “View Data”.
My App Formula for [KPI_Value] is:
(
COUNT(
SELECT(
Reporting\[Code\],
AND(
\[Statut\] = "Absent",
MONTH(\[Starting_Date\]) = ANY(SELECT(Settings\[MonthNumber\], \[SelectedMonth\] = TRUE)),
YEAR(\[Starting_Date\]) = YEAR(TODAY())
)
)
)
/
COUNT(
SELECT(
Reporting\[Code\],
AND(
MONTH(\[Starting_Date\]) = ANY(SELECT(Settings\[MonthNumber\], \[SelectedMonth\] = TRUE)),
YEAR(\[Starting_Date\]) = YEAR(TODAY())
)
)
)
) * 100
I’m not sure why the value always returns 0, even though there are matching rows in the Reporting table.
In the Card View, I set:
Header = [KPI_Name]
Summary = [KPI_Value]
Display style = Large
Could anyone help me figure out what I’m missing or doing wrong?
Thanks in advance!