Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Visualization in Workspace

Avatar

Level 1

Hello Peeps,

It is my first post on here.  I am seeking some workspace assistance and need to see if anyone can guide me. 

I have been asked to create a report like below. I need 3 metrics on one graph.  With the bar and the lines- is this sort of graph possible in workspace area? Any other way to represent this in workspace?

1639954_pastedImage_0.png

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

not exactly the same, but close to. just try the link "in as workspace project" which should be available on every report screen.

if thst doesn't work, follow those steps within a workspace project:

1) create new table with desired metric (orders) and dimension (days) having the main date range (for green bars, change on top right if needed)

2) right click on metric header "orders" and select "compare to other date range" and select the desired  date ranges for comparison. this will add new columns for the desired date ranges. remark: the dimensions on the left (rows) will stay the same. but in each cell of the new columns you will see a small date indicating whith the "compare date"

having this table just create a visualization like "bar chart" or "line".

remark: you can change the "alignment of dates" by changing the settings: open the gear icon of the dimension "day" to change from "start at same row" to "do not adjust" (or something similar, don't have access right now to check)

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

not exactly the same, but close to. just try the link "in as workspace project" which should be available on every report screen.

if thst doesn't work, follow those steps within a workspace project:

1) create new table with desired metric (orders) and dimension (days) having the main date range (for green bars, change on top right if needed)

2) right click on metric header "orders" and select "compare to other date range" and select the desired  date ranges for comparison. this will add new columns for the desired date ranges. remark: the dimensions on the left (rows) will stay the same. but in each cell of the new columns you will see a small date indicating whith the "compare date"

having this table just create a visualization like "bar chart" or "line".

remark: you can change the "alignment of dates" by changing the settings: open the gear icon of the dimension "day" to change from "start at same row" to "do not adjust" (or something similar, don't have access right now to check)