[Mondrian] Measure spanning across two rows in fact table
saurabhnanda at gmail.com
Thu Aug 13 06:31:48 EDT 2009
Julian, are you referring to a CalculatedMember (
I couldn't find a CalculatedMeasure anywhere.
On Thu, Aug 13, 2009 at 3:12 PM, Julian Hyde <jhyde at pentaho.com> wrote:
> You need a calculated measure.
> *From:* mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
> *On Behalf Of *Saurabh Nanda
> *Sent:* Wednesday, August 12, 2009 11:59 PM
> *To:* mondrian at pentaho.org
> *Subject:* [Mondrian] Measure spanning across two rows in fact table
> I'm trying to define a measure whose value is computed by taking quantities
> across two rows in the fact table. How do I do it? Here's what I'm trying to
> Fact table fomat: | Date | URL | Page views | Unique visitors | Session
> count |
> Required measure: Conversion for a given date = number of unique visitors
> on confirmation URL (on that date) / number of unique visitors on search URL
> (on that date) x 100
> Mondrian mailing list
> Mondrian at pentaho.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Mondrian