Visual tricks with charts. EQ-graph

    Hello, Everyone!

     

    Today we gonna make this cute equalized graph:

    p0.png

    I call it "eq" because it similar with equalizer. Maybe it has a different name, no matter. Let's make it live!

    Any data may be converted in rounded values:

    p1.png

    with this expression: round(sum(val)/$(=max(aggr(sum(val),mnt)))*10)

     

    Next we can make a bar chart with calculated dimension ValueList(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19)

    (if we want ten-pieces bars for each "mnt" field):

    p2.png

    As expression we should use: if(Mod(ValueList(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19),2)=0,0.1,1)

    And have a background color for it like:

    if(

    mod(

    ValueList(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19)

    ,2)=0,White(),

    if(round(sum(val)/$(=max(aggr(sum(val),mnt)))*10)>

    pick(

    ValueList(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19)

    ,0,0,1,0,2,0,3,0,4,0,5,0,6,0,7,0,8,0,9)

    ,vGreen,White())

    )

     

    Note: Check Stacked on Style tab.

     

    After that all we have to do is use some color and style variations:

    p3.png

    That's all! Hope you'll like it and if it so - share your opinion!

    Thank you! !