Forum Discussion
MCFNeil
9 years agoQrew Captain
It would be all too easy if QuickBase gave that option because it makes too much sense.
Here is a work-around until that happens.
You will need to summarize the data to a parent table. Already exist, but you may need to create a "Months" or "Quarter" table, depending on the time frame you are looking for in the gauge chart.
You'll then want to create a formula numeric field that displays as a percent.
Have this field add your total that is summarized then be divided by your "goal" (i.e. 100%).
Then you will have a total.
When you create your gauge report, make the value be based on that new field, and your goal will be "1".
Now you have your % gauge report.
Here is a work-around until that happens.
You will need to summarize the data to a parent table. Already exist, but you may need to create a "Months" or "Quarter" table, depending on the time frame you are looking for in the gauge chart.
You'll then want to create a formula numeric field that displays as a percent.
Have this field add your total that is summarized then be divided by your "goal" (i.e. 100%).
Then you will have a total.
When you create your gauge report, make the value be based on that new field, and your goal will be "1".
Now you have your % gauge report.