3 Replies Latest reply on Aug 27, 2018 4:55 PM by Shinichiro Murakami

    Displaying the Restaurant Brand with the most number of records on Map

    Junchen Pan

      Hi All,

      I am doing a small project from Kaggle called Fast Food. I want to display the top1 fast food brand WRT each state on the map. And now I got stuck on doing this. I tried rank(sum(records)) but the advance editing prevent me from changing the restarting point. Can someone help me with this?

       

      And another question is I already have a set with two columns, one is for state(distinct) and the other one is brand name(not distinct). How can I convert this into each brand relating to occurrences of themselves, finally putting them in histogram?

       

      Thanks for any helps,

      The workbook is attached

      Junchen