Best way to get multiple data types in a visualization?

pauljames · 2024-02-19T19:23:27+00:00

There was an error rendering this rich post.

Hey,

I have total sales (in the millions), avg. selling price (max $20/unit) , and then a % metric. I want to have them all together in a time series chart to show trends.

I can't figure this out for the life of me because I can't get them all appropriately graphed without taking one off the graph completely to see.

Make sense? Appreciate any feedback here on recommendations.

Thanks,

Paul

Find more posts tagged with

Visualization

Charting

Accepted answers

ColemenWilson

Could you normalize them against a benchmark? So you are visualizing +/- against that benchmark?

Example:
Total sales benchmark is $1,000,000 and the current month value is $1,200,000

Total sales benchmark is $1,000,000 and the current month value is $1,200,000
1. Graph would show 20% increase over benchmark of 0 (with tooltip to show actual value)
avg. selling price benchmark is $10 and the current month value is $15
1. Graph would show 50% increase over benchmark of 0 (with tooltip to show actual value)
% metric benchmark is 5% and the current month value is 8%
1. Graph would show 60% increase over benchmark of 0 (with tooltip to show actual value)

All comments

ColemenWilson

Could you normalize them against a benchmark? So you are visualizing +/- against that benchmark?

Example:
Total sales benchmark is $1,000,000 and the current month value is $1,200,000

Total sales benchmark is $1,000,000 and the current month value is $1,200,000
1. Graph would show 20% increase over benchmark of 0 (with tooltip to show actual value)
avg. selling price benchmark is $10 and the current month value is $15
1. Graph would show 50% increase over benchmark of 0 (with tooltip to show actual value)
% metric benchmark is 5% and the current month value is 8%
1. Graph would show 60% increase over benchmark of 0 (with tooltip to show actual value)