Skip to main content

Hello community :) 

I have a dimension with all my employee and their packages (with historization). For example: one personn who received a salary increase have 2 rows:

  • first row with start end date of previous package
  • second row with start date as end date of the previous package

Would it be possible to create a formula which allows to have a filter in page which ables to select only the last value in the dimension for each employee (ie the last up to date package)?

 

Thanks a lot!

Hi Alix,

Have you tried using the Last Non Blank aggregator in the view aggregators?

 

You could either put your version as page, or as row/column and have the total (e.g. the last non blank value) shown in the total row/column.

 

The other option would be to create a separate block without your version dimension and add a eREMOVE LASTNONBLANK: Version] in your formula, but I’m not sure this is what you’d want.

 

Let me know if I got your question wrong!

Thanks Francois, I’ll have a look and come back to you :) 

All good on this one now, @Alix Noyon ? Hope so! :)

Reply


Ask your question here!

Terms & ConditionsCookie settings