PoP measures in LookML

We have begun using this way of doing PoP  , but are stuck on two points. 

The biggest is our custom measures. As an example, take the margin of a product. We have a custom measure doing that like this: profit / revenue

But this is a number, and the PoP way doesn't support numbers. So how can we achieve having both the current margin and the margin for last year?

 

Also we have filters and dates - it seems you can't use the PoP without having the date in the table, and sometimes our customers ask to have fx 
product - revenue this year - revenue last year 

and then use a filter to narrow down the period - but it seems we can't do that?

0 0 6
0 REPLIES 0
Top Labels in this Space
Top Solution Authors