Dynamic Pivot Table Heat Map

Comments

10 comments

  • Avatar
    Ronen Avidor

    nice

    0
    Comment actions Permalink
  • Avatar
    Felipe Bispo

    Hi Artem,

    Thanks for sharing this!

    I've tried to implement this script, but it only formatted the first column of my pivot tables. Could you help me with this issue?

    Thanks, Felipe

    0
    Comment actions Permalink
  • Avatar
    Artem Yevtushenko (Edited )

    Hey Felipe, please try the heatmap plugin if the script is not working for you.

    https://support.sisense.com/hc/en-us/community/posts/360001582414-Color-Heatmap

    0
    Comment actions Permalink
  • Avatar
    Artem Yevtushenko

    Felipe, I've updated the script. Please try the new version and let me know if it worked.

    Cheers, Artem

    0
    Comment actions Permalink
  • Avatar
    Elizabeth Wang

    Artem,

    I tried the script and it still only formatted the first column.

    Thanks,

    Elizabeth

    0
    Comment actions Permalink
  • Avatar
    Artem Yevtushenko

    Hi Elizabeth, thanks for your comment.

    Can you take a screenshot of what you're seeing? The script was recently updated to resolve the one column issue.

    Cheers,

    Artem

    0
    Comment actions Permalink
  • Avatar
    Elizabeth Wang

    Hi Artem,

    I added the script today and this is what I see.  This case is specifically when there are multiple values.  The second screenshot shows multiple columns and one value, which seems to work fine.  I am using the Sample ECommerce data as an example.

    Thanks,

    Elizabeth

    0
    Comment actions Permalink
  • Avatar
    Artem Yevtushenko

    Hi Elizabeth, you're looking at a limitation of the script it seems - feel free to edit it to capture multiple values, however.

    I recommend using the out-of-the-box conditional formatting functionality.

    Cheers, 

    Artem

    0
    Comment actions Permalink
  • Avatar
    Delsaran Bigglesworth

    Hey Artem,

    I'm trying to parse out the nulls and turn them black (or just a different color), I tried inserting an else in your loop but that didn't hit its mark. any suggestions?

    0
    Comment actions Permalink
  • Avatar
    Adarsh S

    Does anyone have worked on cohort analysis , if yes can u share any sample of that dashboard code bsc its not wrking as excepted in this forum

    1
    Comment actions Permalink

Please sign in to leave a comment.