Dashboards & Visualizations

Change Color of Sparkline in Dashboard Studio

gabbydm
Explorer

Hello,

I am trying to change the color of the sparkline in my table. I don't have the option to change it using the dropdown menu under "Column-specific formatting" so I'm trying to do it through he Code option. Here is the current code I have: 

{
"type": "splunk.table",
"dataSources": {
"primary": "ds_xNY7uyLU"
},
"title": "Top Notable Sources",
"options": {
"fontSize": "extraSmall",
"columnFormat": {
"sparkline": {
"data": "> table | seriesByName(\"sparkline\") | formatByType(sparklineColumnFormatEditorConfig)",
"sparklineColors": "> table | seriesByName(\"sparkline\") | matchValue(sparklineColorsEditorConfig)"
}
}
},
"context": {
"sparklineColorsEditorConfig": [
{
"string": {},
"value": "#66aaf9"
}
]
},
"showProgressBar": false,
"showLastUpdated": false
}

 

Labels (2)
0 Karma
1 Solution

tej57
Contributor

Hello @gabbydm ,

You can use the following parameters to change the sparkline color from the editor.

sparklineColors
sparklineAreaColors

Note that you can define the cellType to SparklineCell for such visualization.

Reference document - https://docs.splunk.com/Documentation/SplunkCloud/9.0.2305/DashStudio/objOptRef#columnFormat_.28obje...

 

Thanks,
Tejas.

 

---

If the above solution helps you, an upvote is appreciated.

View solution in original post

gabbydm
Explorer

That worked! Thank you for the help!

0 Karma

PaulH
New Member

Hi, can you post a sample code of your solution?

I can't figure it out. 🙂

0 Karma

gabbydm
Explorer

I ended up just adding the hex code of my preferred colors to the options section of the visualization:

 

"viz_AbCd12if": {
            "type": "splunk.table",
            "dataSources": {
                "primary": "ds_xNY7uyLU"
            },
            "title": "Title of Table",
            "options": {
                "columnFormat": {
                    "sparkline": {
                        "data": "> table | seriesByName(\"sparkline\") | formatByType(sparklineColumnFormatEditorConfig)",
                        "sparklineColors": [
                            "#66aaf9",
                            "#66aaf9",
                            "#66aaf9",
                            "#66aaf9",
                            "#66aaf9",
                            "#66aaf9",
                            "#66aaf9",
                            "#66aaf9",
                            "#66aaf9",
                            "#66aaf9"
0 Karma

tej57
Contributor

Hello @gabbydm ,

You can use the following parameters to change the sparkline color from the editor.

sparklineColors
sparklineAreaColors

Note that you can define the cellType to SparklineCell for such visualization.

Reference document - https://docs.splunk.com/Documentation/SplunkCloud/9.0.2305/DashStudio/objOptRef#columnFormat_.28obje...

 

Thanks,
Tejas.

 

---

If the above solution helps you, an upvote is appreciated.

Get Updates on the Splunk Community!

Detecting Brute Force Account Takeover Fraud with Splunk

This article is the second in a three-part series exploring advanced fraud detection techniques using Splunk. ...

Buttercup Games: Further Dashboarding Techniques (Part 9)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...

Buttercup Games: Further Dashboarding Techniques (Part 8)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...