mark048 Posted January 2, 2017 Report Share Posted January 2, 2017 Is there a way to make a chart/graph that would give a visual representation of the progress toward a goal? For example, I have a numerical field that gets an entry every time a table entry is made. There is a goal number associated with that entry table as well. That number remains consistent. So I want a graph to show we have 10 out of 50 complete. Then it may change to 11/50 with the next entry and so on. Thanks, Mark Quote Link to comment Share on other sites More sharing options...
0 Mathilda Posted January 3, 2017 Report Share Posted January 3, 2017 19 hours ago, Pulford said: Is there a way to make a chart/graph that would give a visual representation of the progress toward a goal? For example, I have a numerical field that gets an entry every time a table entry is made. There is a goal number associated with that entry table as well. That number remains consistent. So I want a graph to show we have 10 out of 50 complete. Then it may change to 11/50 with the next entry and so on. Thanks, Mark Hi, I would recommend using column type of chart. Define the following settings on the Configure chart settings screen of the wizard: - Chart settings: define value for the width setting, because chart will be too wide for 1 column. Try using 400px. - Data source settings: select "Use a separate field for each series" - category X axis: leave blank - category Y axis: set "fixed" for Axis value range and in the "to" field define your goal, so you need to put 50 there. Also select "none" in the formatting setting (it's set to % by default) - value1: select a numerical field and select "count" in aggregation. After that save changes. Hope it helps :) mark048 1 Quote Link to comment Share on other sites More sharing options...
0 mark048 Posted January 3, 2017 Author Report Share Posted January 3, 2017 Thank you! Quote Link to comment Share on other sites More sharing options...
0 astroboy Posted May 29, 2021 Report Share Posted May 29, 2021 Hi, Caspio recently launch an App Extension that you may find helpful for this specific workflow. This App Extension is a Gantt Chart that is useful in tracking the progress of every items in your task list. Here's the link: https://www.caspio.com/services/request-info/?e=Gantt Chart You may also check this link to see the rest of the App Extensions: https://www.caspio.com/services/app-extensions/?_ga=2.109578373.1204936084.1622042034-421076417.1617304582 Cheers! Quote Link to comment Share on other sites More sharing options...
0 astroboy Posted May 29, 2021 Report Share Posted May 29, 2021 Also, another App Extension that is useful in tracking your progress towards a goal is the Kanban Board. What makes this unique is the ability to drag and drop items from one field to another. You may check this link to get more information about this: https://www.caspio.com/services/request-info/?e=Kanban Board Quote Link to comment Share on other sites More sharing options...
0 Flowers4Algernon Posted December 23, 2023 Report Share Posted December 23, 2023 Hello! Just wanted to share this video regarding creating reports with charts: Quote Link to comment Share on other sites More sharing options...
Question
mark048
Is there a way to make a chart/graph that would give a visual representation of the progress toward a goal?
For example, I have a numerical field that gets an entry every time a table entry is made.
There is a goal number associated with that entry table as well. That number remains consistent.
So I want a graph to show we have 10 out of 50 complete. Then it may change to 11/50 with the next entry and so on.
Thanks,
Mark
Link to comment
Share on other sites
5 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.