Jump to content
Sign in to follow this  
Mafia2020

Pie-Chart based on Find and Value List problem

Recommended Posts

Hello, I am in a bit of a pickle and I was wondering if someone can help me out. I am working on a database and I need to do some charting based on the values input from a value list (and I absolutely have no clue on how to tell FMP to go ascertain how much of each the user input) and I need the chart to change based on filtering (which is done with a button to exclude certain values based on a certain criteria, e.g. excluding items which I acquired for free or items that went unsold) and I was wondering if that would be possible and how? Any pointers?

Thanks in advance.

Test.zip

Share this post


Link to post
Share on other sites

I am not sure what your exact question is but if I am guessing perhaps you are looking for something like this?

Test_pie.zip

Share this post


Link to post
Share on other sites

Thank you very much, I think you got exactly what I wanted to achieve and with your help I was able to implement the script and functions into my database. I would like to ask another question though, in the chartI have plenty of categories and I am more interested in the more relevant ones (big percentages) rather than the very small ones (small percentages) otherwise the whole chart ends cluttered with too much non-relevant data. Is there anyway to tell FMP instead of presenting tens of slices to "group" the percentages smaller than X into a single "Misc" entry? I mean, instead of having: A: 70% B: 25% C:1% D: 0.1% E 0.9% F:3% to get: A: 70% B:25% Misc:5%

Share this post


Link to post
Share on other sites

Hello,

I finally managed to create a decent pie-chart with the help of a forumer and it looks like the picture attached. I was wondering if it would be possible to group all percentages under a fixed amount (let's say under 5%) into a single slice "Misc". In another thread I have read that it involves the creation of several other fields and calculations but I wonder how to accomplish that. So far the graph takes data from a single summary field (s_Profit) and labels from another field with an attached value list (DE_Item Type). How to tell the program to group everything under 5% in a single misc slice?

Thanks in advance.

post-102418-0-97847500-1344783519_thumb.

Share this post


Link to post
Share on other sites

I have merged your two topic about Charting. Please do not start a new topic when asking follow up questions.

Lee

Share this post


Link to post
Share on other sites

Sorry, I just thought my new question belonged to the calculations forum so I placed that here, didn't mean to infringe any forum rules though.

Share this post


Link to post
Share on other sites

Try this out. You can make the pie chart not be based on the current set but rather a script that generates the figures.

This file also addresses your other post.

http://fmforums.com/forum/topic/85662-different-sort-order-on-the-same-layout-is-it-possible/

 

 

 

Tags: Custom Chart

Test_pie2.zip

Share this post


Link to post
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.