Jump to content

Recommended Posts

Posted

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.

Posted

Its probably best to turn this into a report to get the calc working.

I think what is happening is you end up with 0 as the else for the other countries, so the divide will always be zero.

You may have to pre-process and hold the results to get the values in the same record.

Posted

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

Posted

I think I got it!

It appears I needed to click on Calculate after aggregation at the point of creating the calculation.

 

By doing so this did yield the proper result.

 

image.png1548939 4.34 KB

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...