4 Replies Latest reply on Nov 27, 2017 5:02 PM by Anisha Jhamb

Please suggest the best possible visualizations for the following data structure

Anisha Jhamb Nov 20, 2017 10:25 PM

Hi All,

I am looking for some suggestions to visualize the below structure of data:

Dimension1	Dimension2	Attribute1	Measure1	Measure2	Measure3	Measure4
Value 1	ValueX	Att1	10%	500	19%	1,000,000
	ValueY	Att2	30%	250	10%	84,000
	ValueZ	Att3	25%	10	25%	995,000
Value 2	ValueA	Att4	50%	1500	29%	600,000
	ValueX	Att2	20%	2250	30%	134,000
	ValueZ	Att3	95%	1110	5%	77,000

The goal is to fit all this info in one visualization and keep it very simple for the user to comprehend, nothing too complex.

(I can't attach a workbook as the actual data is sensitive, any example using a superstore dataset would be helpful)

Thanks in Advance!

1. Re: Please suggest the best possible visualizations for the following data structure

lenaic.ridinger Nov 27, 2017 6:55 AM (in response to Anisha Jhamb)
Hello Anisha Jhamb,

What do you think about my viz?
I have attached it (10.3) to this post.

Let me know what you think + feedback so we can arrange this together,
cheers,

----------
Lénaïc RIÉDINGER, Global Community Engineer Tableau
Tableau Community Forums | Knowledge Base
If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!

Test Anisha.twbx 20.5 KB
Like Show 0 Likes(0)

Actions
2. Re: Please suggest the best possible visualizations for the following data structure

Patrick A Van Der Hyde Nov 27, 2017 4:37 PM (in response to Anisha Jhamb)

Anisha,

Are the measures with percentages - a percentage of each Dimension value or are they percentages across all of the data? Is there a coorelation between Measure 1 and 2? and a related one between 3 and 4?

Knowing the number of potential values for each Dimension would help too. Are we talking <10 or thousands?

If you can supply a bit more data that matches your true scenerio, it would be easire to assist.

Packaged workbooks: when, why, how

Patrick
Like Show 0 Likes(0)

Actions
3. Re: Please suggest the best possible visualizations for the following data structure

Anisha Jhamb Nov 27, 2017 4:58 PM (in response to lenaic.ridinger)

Thanks for your input!

But, I cant work with multiple axes.
Like Show 0 Likes(0)

Actions
4. Re: Please suggest the best possible visualizations for the following data structure

Anisha Jhamb Nov 27, 2017 5:02 PM (in response to Patrick A Van Der Hyde)

Thanks for your reply!

Measures are interrelated. For example - take Sales

Measure1 - MOM Sales change
Measure2 - Sales
Measure3 - YOY Sales Change
Measure4 - YTD Sales Change

Dim1 - typically 8-10 values
Dim2 - typically 1-5 values
Dim3/Att1 - 6-10 values for every Dim2 value

Hope this provides a better picture.
Like Show 0 Likes(0)

Actions

Go to original post