topic Re: ScatterPlot Formatting in Dashboards & Visualizations

How to do ScatterPlot Formatting?

lk83 — Thu, 07 Jul 2022 17:05:02 GMT

Team I need help with a Scatter Plot Visualization.

Here's the Search I'm using:

| inputlookup append=t 07012022KPI_Formatted.csv
| eval Deployed=strptime(Deployed, "%m/%d/%y")
| fieldformat Deployed = strftime(Deployed, "%m/%d/%y")
| table "Deployment Success" Deployed "Deploy Lead Time"

It populates the Statistics I'm looking for:

However, when I click Visualization, the Deployed axys is not showing the Dates but as numbers 0.....

Screenshot for reference of my imported CSV.

Any ideas how to fix it?

Thank you

Re: ScatterPlot Formatting

ITWhisperer — Thu, 07 Jul 2022 17:05:11 GMT

What is it you are attempting to show? Scatter plot against a timeline is perhaps not the right visualisation?

Re: ScatterPlot Formatting

lk83 — Thu, 07 Jul 2022 17:21:16 GMT

ITWhisperer,

I was asked to use a scatter plot to show:

Vertical (Y) the Deploy Lead Time (amount of time from Development until Production Deploy for a code application)

Horizontal (X) the Date of the Production Deploy.

The Plot should show the status of the Production Deploy of that Date (Flawless, Successful, Fail).

Something like the following screenshot, but notice that I had the day column and no longer use that....

Thank you so much for your time!

Re: ScatterPlot Formatting

ITWhisperer — Thu, 07 Jul 2022 19:12:42 GMT

Unfortunately, the x-axis has to be numeric for a scatter plot, so formatting as a date doesn't work the way you would like.

Re: ScatterPlot Formatting

lk83 — Thu, 07 Jul 2022 19:15:22 GMT

Would you have any recommendation on a good Visualization for it?

Thank you,