Skip to main content

I have a .csv structured like this (I have more columns):

Make new dimension / make text values as columnsSo I have for each user name some columns with hashtags they use.

Now I want to know which account is using which hashtags and I also want to know which hashtag is being used most.

How can I do this?

 

Thank you!

1 risposta
  1. 22 gen 2022, 10:01

    Hi Eveline,

     

    You may want to Pivot the hashtag columns,

    then use the Tableau-generated [Pivot Values] column

     

    -- as a Measure like COUNTD( [Pivot Values] )

    to count the # hashtags by Users

     

    -- as a Dimension to do a COUNTD( [user_id] )

    when counting # Users by hashtag.

     

    Yours,

    Yuri

0/9000