Forum Discussion

JesseBruner's avatar
JesseBruner
Qrew Trainee
7 years ago

How do I pull specific items from a table by filters, and take that data and put it into a pie chart?

I need to put a pie chart on the homepage, which shows the price of various jobs with the prefix 0,1, and 2. Each of those are already something that we can filter. Furthermore, we would like to split...
reports and charts
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
You will need to fist make a formula field to calculate the names of your pie slices.

The formula might be

var text Prefix = left([Job Code],1);

if($Prefix="1" and [Type]="OEM", "1a", "1b", $Prefix)