Jump to content

Darren S

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Darren S

  • Rank
  1. Thanks very much. That was so simple! The answer is sometimes right in front of me - I appreciate you pointing it out.
  2. Thanks for the reply. I went with the option to modify the script to exit after the 10th group. To do this I sort by descending order, according to Sales. This works well but will gives me the largest Sales values first. When I chart this as a Bar chart the largest values are on the bottom of the chart. I would prefer the largest to be at the top. I'm not sure how to do this using the Fast Summaries method because the number of Customers will vary. I'm not sure how to start collecting values from the last 10 groups if I were to sort in ascending order. Should I try and work out how to collect the values from the last 10 groups, or should I attempt to reorder the list in the delimited field? Is there another method I should use? Thanks again.
  3. I have 2 fields that are used to create a simple Bar Chart layout: Customers and Sales. Each field is a list of values I have generated from summary reports using Mikhail Edoshin's Fast Summary technique. Each of the 2 fields contains many values (maybe up to 30 or 40 entries), sorted by Sales. I would like to chart the top 10 Customers (by Sales). How would I use a script to modify the data in each field to keep only the first (or last) 10 values? Thank you.
  4. I have a sales team and we are using FM to track our clients and sales. We have a server version that is hosting our solution. Each sales person has their own data file (ie. separate databases). We went down this path so that we can more easily manage the division of common and sensitive data. I am creating a 'Dashboard' where an admin user can view data from each database. I can do this manually by creating multiple External Data Source entries and adding the relevant tables in the Relationships screen under Manage Databases. Then I can add the fields I need into the various layouts. I am looking for a method to script the process of adding a new database to the Dashboard. What I would like to do is add a new database to the FMS data folder, then 'choose' it from the Dashboard file. The script would then add the database to the External Data Source list and add it in the Relationships Graph. I would also need to script the addition of the new data source in my layouts. I hope I am explaining this properly. I am hoping for some guidance if this can be done and how to get started. Thanks.
  5. Darren S

    Fixing Y Axis

    I have a chart where the user can select the product type and it shows the sales for that product only. There is also an option to show total sales. My chart has a maximum Y axis value of $6,000,000. No values exceed that limit. When the user selects different products, the width of the chart changes. The Y axis limit and increments are the same. The X axis is also the same (being 12 columns - one for each month). Do you know how to fix the size of the chart? It appears to dynamically resize based on the data.
  6. Darren S

    Fixing Y Axis

    Thank you very much. I thought I had tried that but setting a maximum value worked. I still have an issue where the chart resizes the width as I change the Y axis values. Is there a way to stop this behaviour?
  7. Darren S

    Fixing Y Axis

    Hi, I have a layout that includes a chart that totals sales for each month - January to December. There is also a drop down list where I can select the year for the chart to display results. Each time I select a year the scale of the Y axis changes. For example, if maximum sales for a given month in 2017 are $3.9M it will show $4.5M as the maximum value on the Y axis. In 2018 the maximum for a month is $4.9M, so the Y axis changes to show a maximum of $5.5M I want to be able to set a scale for the Y axis so that it does not change. Ideally I could create a variable for the user to preset. As an example, the user could set the maximum at $7M. This way, the charts are a better visual comparison as we change the year to be viewed. I tried creating a second series that has the limit set as the data (I am using simple bar chart) but with no control over making that invisible this doesn't appear to be a solution. I can't see any other settings on the Chart editor where I can fix in the scale of the Y axis. Any ideas? Thanks.
  • Create New...

Important Information

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