Creating a new measure, with the last editing user's name displayed in the table

Questions & Answers
1

Good afternoon! I am new to using easyBI in confluence.
Please tell me how to create a new measure to display the username in the table, who last edited the page

2

Hi @jon33367,

Unfortunately, eazyBI currently doesn’t have such information out of the box. However, the measure “Page versions created” can be used to tie the last date and the author together and return that information. Unfortunately, if two users update a page on the same day, both will be returned. Please see the suggested calculated measure formula below:

CASE WHEN [Page].CurrentHierarchyMember.Level.Name = 'Page'
AND NOT IsEmpty([Page].CurrentMember.Get('Updated at'))
THEN
--[Page].CurrentMember.AllProperties
Generate(
  Filter(
    [Author].[User].Members,
    ([Time].[Day].DateMember(
      [Page].CurrentMember.Get('Updated at')
    ),
    [Measures].[Page versions created]) > 0
  ),
  [Author].CurrentMember.Name,
  ', '
)
END

See the expected result below:

Screenshot 2022-10-13 at 09.44.17
Screenshot 2022-10-13 at 09.44.172134×1224 407 KB

Please see the eazyBI documentation page for more details on defining calculated measures - Calculated measures and members.

Best,
Roberts // support@eazybi.com

3

Good afternoon! Unfortunately this code doesn’t work for me.
CASE WHEN [Page].CurrentHierarchyMember.Level.Name = ‘Page’
AND NOT IsEmpty([Page].CurrentMember.Get(‘Updated at’))
THEN
If you take this code separately, it works (but not exactly what I need)
–[Page].CurrentMember.AllProperties
Generate(
Filter(
[Author].[User].Members,
([Time].[Day].DateMember(
[Page].CurrentMember.Get(‘Updated at’)
),
[Measures].[Page versions created]) > 0
),
[Author].CurrentMember.Name,
', ’
)

4

Hi @jon33367,

I am sorry to hear that. Please share more details and specify the requirement and the desired report structure.

Best,