Alteryx designer Discussions

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

Alteryx Charts workflow

Highlighted
Meteor

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

Highlighted
Castor
Castor

Hi @porpergrey 

 

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

Highlighted
Meteor

@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. 

Highlighted
Meteor

@danilang could you please help me.. Im stuck

Highlighted
Castor
Castor

hi @porpergrey 

 

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

 

 

Highlighted
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?

Highlighted
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?

Highlighted
Meteor

@danilang Facing this issue in my workflow rn.

Highlighted
Castor
Castor

Hi @stevegeorge @porpergrey 

 

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

Highlighted
Meteor
 
Labels