8 Replies Latest reply: Jul 17, 2017 10:05 AM by John Cavoulas RSS

    Get Max Name and Value Hourly

    John Cavoulas

      So, I've been struggling with this trying to get it to work. I've gotten most of it but just can't get over the hump. I am not strong in calculated dimensions and suspect that is where it will be fixed.

       

      I need to display the NAME and maximum value for a particular NAME hourly throughout the day. I have multiple NAME's with a VALUE and it may or may not be associated to an HOUR of any given day. The attachment I provided has a table with 3 days of data. Each bar shows the correct VALUE but not the correct NAME. For the first date of 7/1 and HOUR 00 I would expect to see the VALUE of 162034 (which it does) and the NAME of HOS (which it doesn't). For HOUR 01 I expect to see VALUE of 141720 (which it does) and again NAME of HOS (which it doesn't).


      Also, if I select TYPE A or B I expect to see the associated max VALUE's and associated NAME's.


      I also need the legend to display the NAME and associated color. Note that this chart is showing only one color but again, the calculated NAME dimension isn't right and all are showing 3469.


      I am suspecting my issue is in my calculated dimension but I've tried every permutation I could think of with no success. I've attached my document. If the answer partially lies in the script just export and reload the table.


      Regards,

      John