Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have some data that I'm trying to display in a single bar chart instead of several separate ones. Really hoping someone can help
My data looks like this:
Country | Internet | Text | Video | |
---|---|---|---|---|
UK | 1 | 1 | 1 | 5 |
USA | 2 | 2 | 2 | 4 |
India | 3 | 3 | 1 | 1 |
UK | 2 | 3 | 1 | 2 |
UK | 6 | 4 | 3 | 3 |
The numbers in the columns Internet, Text, Email and Video represent the frequency that people use these media types.
I would like to display the results of this table in a stacked chart as follows:
Would also like to create a list box that allows me to filter by country.
Any help to acheive this would be much appreciated!
Many thanks,
Katie
Hi Katie
Please find the attachment. Hope this gives you an idea. This is just rough, You can enhance on your requiremen,t
Hi Katie
Please find the attachment. Hope this gives you an idea. This is just rough, You can enhance on your requiremen,t
Is this what you are looking for?
---------------------------------------------------------------------------------------------
OrgTable:
LOAD
INLINE [
Country, Internet, Text, Email, Video
UK, 1, 1, 1, 5
USA,2, 2, 2, 4
India, 3, 3, 1, 1
UK, 2, 3, 1, 2
UK, 6, 4, 3, 3
]
;
NewTable:
CrossTable (Type,Value , 1)
LOAD *
RESIDENT OrgTable;
DROP TABLE OrgTable;
----------------------------------------------------------------------------------------------------------
Create calculated dimension containing a set of if then statements for the groupings.
=
if(Value = 1, 'Every Day',
if(Value = 2, 'Every Week',
if(Value = 3, 'Every Month',
if(Value = 4, 'Every Year',
if(Value = 5, 'Rarely',
if(Value
= 6, 'Never')
)
)
)
)
)
Thanks so much for this - it works perfectly!
Thank you dibblemc - I used KStreak S's answer first and it worked really well, although I did find your reply really helpful