Hello,
I can’t find the solution to my problem on the community.
On a dashboard, I need to display a percentage in a “figure” widget.
This percentage must represent the ratio between the number of rows in my table and a value in a status column.
Does anyone have a solution?
Thanks.
Hi Muriel,
You can achieve this by creating a calculated field that divides the row count by the count of your specific status condition, then formatting it as a percentage. Depending on the platform you’re using, this usually involves applying an aggregation function like:
COUNTIF(Status = "your_value") / COUNT(*)
Once you have that measure, you can display it directly in your “figure” widget and set the display format to pourcentage.
If you share which BI tool or dashboard platform you’re working with, I can provide a more tailored formula example.