Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

Is it possible to do more complex formulas with Graphs in De...


Ben Maxwell

Recommended Posts

Is it possible to do more complex formulas with Graphs in Designer Studio 8.207 27

Here is my example using the CARS file

A) Create calculated field to aggregate Body Sales where Country = Japan

 

B) Create calculated field to aggregate Body Sales where Country = Japan

 

This produces this graphs (which is correct)

 

image.png786773 2.06 KB

 

When trying to do a formula which takes JAPAN_SALES / ENGLAND_SALES, the graph show reflect 6.5, but it doesnt even come close.

This is the formula I attempted :

 

Is there a means to make this calculation in Designer Studio When I wouldve done this in App Studio I wouldve created 2 hold files prior to doing the final calculation.

Link to comment
Share on other sites

One of the challenges in Designer Studio is that you are unable to create Hold files on the fly when creating your charts. In App Studio this was a non-issue.

Now when I tried building this same graph in InfoAssist, I did become successful when using a Compute statement as opposed to a 'Define.

Im going to do some more tinkering, but is it possible that Designer Studio (Version 8.207 27) doesnt offer these 2 distinct options

 

image.png856468 13.6 KB

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...