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?
As for date filtering, if I understand you correctly you would want to select these fields:
product dimension
revenue measure
revenue last year measure (pop type, with value_to_date: yes)
(maybe) date_year
And filter on:
date_year = current year
I’m not sure whether you also need to group by date_year to make the PoP work as you say, but you could simply hide it from your viz if so. Then filter on the “current” revenue date range, then the PoP measure feature will still allow the previous year’s data into the revenue last year measure. If you set that measure to have value_to_date: yes it will also filter previous year data to only the days which have transpired in the “current year,” even though the filter is only for “current year.” It actually knows what today’s date is and applies the same date range to previous years.
Thanks for getting your hands dirty with the new PoP measure!
Amazing to hear about the possibility for the number type!
Regarding the date filters, we still can’t make it work.
We have set up a test with some random numbers to show you what we mean. This screenshot below is if we have our date filter to be “this year”.
This is both if we have value_to_date = yes or if we have set it to no. It does not seem to make any difference.
Our use case is that our customers most of the time would like to specify a date range (sometimes last 30 days, last 90 days or sometimes a specific date range), and then expect to see the numbers per day for that date range and the corresponding numbers for the same day last year.
EDIT: I can see our instance has not yet received this update, and that might be why we are having problems. I will get back to you when our instance has been updated to the latest version!
