turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- BI
- /
- Visual Analytics
- /
- Using combined measures in one graph

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

11-19-2014 07:46 AM

Hi all.

I have Categories X, that can have values X_1 and X_2 and Y, that can have values Y_1 and Y_2. The variable That I want is defined as the product of the fraction of all records for entity E that have X_1 and Y_1. For entity E I have many records. So for a given entity, I have many lines that in column X show either X_1 or X_2 and the same for Y, and in some graph I want 1 number per entity that has (number of X_1 for entity E divided by total number of records for E, times the number of Y_1 divided by the total number of records for E). Anyone has an idea of how I can do that?

Thanks in advance!

Marcel