Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Alteryx Charts workflow

clarrock
8 - Asteroid

Hi Team,

 

This is my Table on excel - 

 TotalCarBike Bus
02-09-201914761

03-09-2019

218013
04-09-2019426432
05-09-20193141116
06-09-201910190
09-09-2019264220
10-09-2019303819
11-09-20193211219
12-09-2019193106
13-09-2019318023
16-09-2019231814
17-09-2019215412
18-09-2019181413
19-09-20197223
20-09-2019291127
23-09-2019194510
24-09-2019174310
25-09-201912237
26-09-2019140410
27-09-20193210220
30-09-2019161093

I want to create a chart exactly like this that I've created in excel? If you could please attached your Workflow.

IMG_20200114_224826__01.jpg

15 REPLIES 15
danilang
19 - Altair
19 - Altair

Hi @clarrock 

 

While the graphing capabilities of Alteryx are improving, it's real strength lies in data prep and analysis. Here's the closest I could easily get.

 

r.png

 

Dan

clarrock
8 - Asteroid

@danilang

 

When modifying the data. Why isn't my chart modifying. It still remains the same. Try to put a negative number in one of the columns.. The chart doesn't change. 

clarrock
8 - Asteroid

@danilang could you please help me.. Im stuck

danilang
19 - Altair
19 - Altair

hi @clarrock 

 

It looks like you've found a bug, or at least an inconsistency, in the Interactive Chart tool

 

Here's what you're expecting. Note -2 in the 4th bar

 

Excel.png

 

When you display this in Alteryx you get the following. In the 4th bar the -2(green) is overlapping the 11, yellow.  

grouped.png

 

If you change the mode to grouped bar instead of stacked, you get which is closer to what you're expecting

 

grouped.png

 

Open a ticket at support@alteryx.com and attach this workflow

 

Dan

 

 

henrygeorge
8 - Asteroid

@danilang Got it with negative changes there is an issue/bug. But I have a problem too when running this data on my main workflow -

 

Let me explain -

I run two charts that are exactly the same. So when the chart run they are attached/rendered to a PPT. The height of the bar as well as inside bar height are accurate but the values inside the yellow, red and grey are incorrect. Every time I run with new values I get odd numbers.

 

Is this some kind of problem with Alteryx charts. Should I use the Block Until Done tool?

henrygeorge
8 - Asteroid

@danilang but when I click configure chart in the Interactive Tool they all automatically get accurate. Why when running it comes wrong but when opening the tool it's accurate?

clarrock
8 - Asteroid

@danilang Facing this issue in my workflow rn.

danilang
19 - Altair
19 - Altair

Hi @henrygeorge @clarrock 

 

When I render a single chart to a pptx file, the values in the output always match with the values in the input.  I've attached 2 pptx files rendered with different starting data for bar 1

 

Can you attach your workflow and some sample data so I can try it?

 

Dan

clarrock
8 - Asteroid
 
Labels