Ratio of Measures in Adhoc View

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

Is it possible to create a ratio of 2 measures in an Adhoc view ?    A simple example would be 

- Measure of Total Customers
- Measure of Total Female Customers

The required ratio is 

- Percent of Female Customers .

I just cannnot seem to find a way to do ratios inside the Adhoc view designer. 

 

 

nnath's picture
1
Joined: Jul 1 2010 - 2:30pm
Last seen: 7 years 10 months ago

1 Answer:

i had the same problem 

you could also create a reports /view from a "domain"

while creating a domain you have diffrent kinds of avaliable fields to add to you dataset ( the domain dataset)

and calculation fields are one of them.

amit.barkai's picture
Joined: Feb 27 2013 - 8:33am
Last seen: 7 years 8 months ago
Feedback