Home/ Questions/Q 3386
In Process

vinish.ai Latest Questions

  • 0
  • 0
Asked: 2020-11-15T16:24:38+00:00

How to graphically display the completeness of the task?

  • 0
  • 0

Hi!

I’d like to display completeness graphically. For instance, if I have 3 tasks and 1 is done, how to display graphically percent of the completeness?

Thanks in advance!

oracle apex
Share
Leave an answer

Leave an answer

Browse

5 Answers

  2. This answer was edited.

    In the report, take one more column as follows:

    select ticket, total_tasks, tasks_done, 
   (tasks_done*100/total_tasks) pct_tasks
from yourTable

    Now for the pct_tasks column, specify the below HTML expression in the HTML expression field:

    <span style="display: block; width: #PCT_TASKS#%;background-color: green; color: white;text-align:center;">#PCT_TASKS#%</span>

    You can modify CSS according to your need.

  3. This answer was edited.

    Thanks for the responses!

    Report where I want to display progress bar is different table then tasks. And I don’t have column like tasks_done, I use status column with different types of status.

    I use IG report to display tickets, how can I add progress bar to IG from tasks table? 🙂