Forum Discussion

sabedin's avatar
sabedin
Helper I
8 years ago
Solved

Top visited category description

I need help with the attached file. Please download it and see.   I need a calculated column in 'Member_event_facts' table. I need it to show the top visited category name (club_event_groups[naam])...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    sabedin

     

    Hi, try this:

    Top Visit Category =
VAR RankingContext =
    VALUES ( Club_event_groups[naam] )
RETURN
    CALCULATE (
        FIRSTNONBLANK ( Club_event_groups[naam]; Club_event_groups[naam] );
        TOPN ( 1; ALL ( Club_event_groups[naam] ); [Total visits] );
        RankingContext
    )

    Regards

    Victor

sabedin's avatar
sabedin
Helper I
8 years ago

Hi Jimmy, thanks for replying.

 

Please check the calculated column Top Selling Category, with this I was able to get the Count of most visited category. Maybe you can you modify it somehow so we get the actual name (naam) not the Count.

 

Top Selling Category = 

VAR
    RankingContext = values(Club_event_groups[naam])
Return
CALCULATE([Total visits],
     TOPN(1,all(Club_event_groups[naam]),[Total visits]),
     RankingContext)

 

Thanks again!

sabedin's avatar
sabedin
Helper I
8 years ago

Anyone, please?

  • sabedin's avatar
    sabedin
    Helper I
    8 years ago

    Sorry to bother MrMattAllington, Can you please have a look at this?

     

    Thank you!

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      8 years ago

      sabedin

       

      Hi, try this:

      Top Visit Category =
VAR RankingContext =
    VALUES ( Club_event_groups[naam] )
RETURN
    CALCULATE (
        FIRSTNONBLANK ( Club_event_groups[naam]; Club_event_groups[naam] );
        TOPN ( 1; ALL ( Club_event_groups[naam] ); [Total visits] );
        RankingContext
    )

      Regards

      Victor

      • sabedin's avatar
        sabedin
        Helper I
        8 years ago

        Great, thanks a lot Senjor Victor :)