AnsweredAssumed Answered

First Attempt at FMP12 Chart,

Question asked by MattLeach on May 3, 2012
Latest reply on May 9, 2012 by MattLeach

I have not done much work with FileMakers charting capabilities in the past and this is my first attempt in making a chart with FileMaker 12 and im not really getting anywhere.

 

I have a table that consists of 3 calculation fields, each using ExecuteSQL Calculations:

 

Count_Clients - ExecuteSQL ( "SELECT count (*) FROM TechSupport WHERE Client = 1"; ""; "")

Count_OnSub - ExecuteSQL ( "SELECT count (*) FROM TechSupport WHERE Client = 1 and Maint = 1"; ""; "")

Count_OffSub - ExecuteSQL ( "SELECT count (*) FROM TechSupport WHERE Client = 1 and Maint != 1"; ""; "")

 

So far i've tried to setup the chart using Slice Data of Main::Count_OffSub & Main::Count_OnSub but the chart remains one solid color. I'm pretty sure i'm doing something wrong.

 

I would like to produce a pie graph showing the percentage of clients OnSub and OffSub. Using FM12's new charting setup, how would i be able to accomplish this?

 

Thanks

Outcomes