Skip to main content

Hi everybody,

I am making an event calendar for next year. This calendar contains all different kinds of events (like the winter olympics 2026, valentines day, etc.). This information is stored in a boolean metric dimensioned by Day, Event and Business Unit. 

Like so:
 

Next - I would like to summarize this information in a text metric dimensioned by week and business unit. I would like to create a simple textlist of the Event dimension where any boolean is true. Like so:

  • W6 FY 26: Winter Olympics 2026
  • W7 FY 26: Winter Olympics 2026, Valentines day

How to best go about this? Any help is much appreciated. Thanks!

 

Hi Bas,

I like this calendar use case!

Here is a formula that should help you:

IFDEFINED('boolean metric', Event.Name)[by firstnonblank: Day.Week][remove textlist: Event]

EDIT: the correct formula should be IF('boolean metric', Event.Name))by firstnonblank: Day.Week]]remove textlist: Event]


It checks if the boolean is true, and returns the Event’s name.

then it keeps only the first non blank result by Week (so you avoid having “Winter Olympics, Winter Olympics, Winter Olympics” for W6FY26) 

Then concatenates all text results while removing the Event dimension.

So you should get a text metric dimensioned by Week and Business Unit.

 

Please let me know.

Best,

 

Hey Benoit!

You’re truly a wizard! I would have never come up with that myself 🙂 But it totally works! Thank you so much!



 

Bas

Glad it worked!

Actually, I made a small ‘mistake’, it should be IF() instead of IFDEFINED()
IF() would only take True, IFDEFINED() takes True and False.

 

And going further with this calendar use case, you can imagine having an automation to send a notification to relevant users about this week’s events or next week’s! 

 

Enjoy!

Reply


Ask your question here!

Terms & ConditionsCookie settings