Hi There
I am struggling with the svg Settings
i cant manage to get the sizes right
IF(
OR(
ISNOTBLANK([1]),
ISNOTBLANK([2]),
ISNOTBLANK([3]),
ISNOTBLANK([4]),
ISNOTBLANK([5])
),
CONCATENATE(
"data:image/svg+xml;utf8,<svg xmlns='http://www.w3.org/2000/svg' width='800' height='160'>",
,
IF(ISBLANK([1]), "",
IF([1] = "L",
"<rect x='0' width='160' height='160' fill='%23ff4500' rx='8'/><text x='80' y='80' dominant-baseline='middle' text-anchor='middle' fill='white' font-family='Arial' font-size='80' font-weight='bold'>L</text>",
IF([1] = "D",
"<rect x='0' width='160' height='160' fill='%23ffbf00' rx='8'/><text x='80' y='80' dominant-baseline='middle' text-anchor='middle' fill='white' font-family='Arial' font-size='80' font-weight='bold'>D</text>",
"<rect x='0' width='160' height='160' fill='%2300b341' rx='8'/><text x='80' y='80' dominant-baseline='middle' text-anchor='middle' fill='white' font-family='Arial' font-size='80' font-weight='bold'>" & [1] & "</text>"
)
)
),
IF(ISBLANK([2]), "",
IF([2] = "L",
"<rect x='160' width='160' height='160' fill='%23ff4500' rx='8'/><text x='240' y='80' dominant-baseline='middle' text-anchor='middle' fill='white' font-family='Arial' font-size='80' font-weight='bold'>L</text>",
IF([2] = "D",
"<rect x='160' width='160' height='160' fill='%23ffbf00' rx='8'/><text x='240' y='80' dominant-baseline='middle' text-anchor='middle' fill='white' font-family='Arial' font-size='80' font-weight='bold'>D</text>",
"<rect x='160' width='160' height='160' fill='%2300b341' rx='8'/><text x='240' y='80' dominant-baseline='middle' text-anchor='middle' fill='white' font-family='Arial' font-size='80' font-weight='bold'>" & [2] & "</text>"
)
)
),
IF(ISBLANK([3]), "",
IF([3] = "L",
"<rect x='320' width='160' height='160' fill='%23ff4500' rx='8'/><text x='400' y='80' dominant-baseline='middle' text-anchor='middle' fill='white' font-family='Arial' font-size='80' font-weight='bold'>L</text>",
IF([3] = "D",
"<rect x='320' width='160' height='160' fill='%23ffbf00' rx='8'/><text x='400' y='80' dominant-baseline='middle' text-anchor='middle' fill='white' font-family='Arial' font-size='80' font-weight='bold'>D</text>",
"<rect x='320' width='160' height='160' fill='%2300b341' rx='8'/><text x='400' y='80' dominant-baseline='middle' text-anchor='middle' fill='white' font-family='Arial' font-size='80' font-weight='bold'>" & [3] & "</text>"
)
)
),
IF(ISBLANK([4]), "",
IF([4] = "L",
"<rect x='480' width='160' height='160' fill='%23ff4500' rx='8'/><text x='560' y='80' dominant-baseline='middle' text-anchor='middle' fill='white' font-family='Arial' font-size='80' font-weight='bold'>L</text>",
IF([4] = "D",
"<rect x='480' width='160' height='160' fill='%23ffbf00' rx='8'/><text x='560' y='80' dominant-baseline='middle' text-anchor='middle' fill='white' font-family='Arial' font-size='80' font-weight='bold'>D</text>",
"<rect x='480' width='160' height='160' fill='%2300b341' rx='8'/><text x='560' y='80' dominant-baseline='middle' text-anchor='middle' fill='white' font-family='Arial' font-size='80' font-weight='bold'>" & [4] & "</text>"
)
)
),
IF(ISBLANK([5]), "",
IF([5] = "L",
"<rect x='640' width='160' height='160' fill='%23ff4500' rx='8'/><text x='720' y='80' dominant-baseline='middle' text-anchor='middle' fill='white' font-family='Arial' font-size='80' font-weight='bold'>L</text>",
IF([5] = "D",
"<rect x='640' width='160' height='160' fill='%23ffbf00' rx='8'/><text x='720' y='80' dominant-baseline='middle' text-anchor='middle' fill='white' font-family='Arial' font-size='80' font-weight='bold'>D</text>",
"<rect x='640' width='160' height='160' fill='%2300b341' rx='8'/><text x='720' y='80' dominant-baseline='middle' text-anchor='middle' fill='white' font-family='Arial' font-size='80' font-weight='bold'>" & [5] & "</text>"
)
)
)
,
"</svg>"
),
""
)
I have 5 columns but for some reason everytime i add a new column to display, the icons become smaller...
I just dont seem to master the sizes
This svg works but i need the icons twice the size
Thank you
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |