Hi Team,
This is my Table on excel -
Total | Car | Bike | Bus | |
02-09-2019 | 14 | 7 | 6 | 1 |
03-09-2019 | 21 | 8 | 0 | 13 |
04-09-2019 | 42 | 6 | 4 | 32 |
05-09-2019 | 31 | 4 | 11 | 16 |
06-09-2019 | 10 | 1 | 9 | 0 |
09-09-2019 | 26 | 4 | 2 | 20 |
10-09-2019 | 30 | 3 | 8 | 19 |
11-09-2019 | 32 | 1 | 12 | 19 |
12-09-2019 | 19 | 3 | 10 | 6 |
13-09-2019 | 31 | 8 | 0 | 23 |
16-09-2019 | 23 | 1 | 8 | 14 |
17-09-2019 | 21 | 5 | 4 | 12 |
18-09-2019 | 18 | 1 | 4 | 13 |
19-09-2019 | 7 | 2 | 2 | 3 |
20-09-2019 | 29 | 1 | 1 | 27 |
23-09-2019 | 19 | 4 | 5 | 10 |
24-09-2019 | 17 | 4 | 3 | 10 |
25-09-2019 | 12 | 2 | 3 | 7 |
26-09-2019 | 14 | 0 | 4 | 10 |
27-09-2019 | 32 | 10 | 2 | 20 |
30-09-2019 | 16 | 10 | 9 | 3 |
I want to create a chart exactly like this that I've created in excel? If you could please attached your Workflow.
Solved! Go to Solution.
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.
Dan
@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.
@danilang could you please help me.. Im stuck
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
When you display this in Alteryx you get the following. In the 4th bar the -2(green) is overlapping the 11, yellow.
If you change the mode to grouped bar instead of stacked, you get which is closer to what you're expecting
Open a ticket at support@alteryx.com and attach this workflow
Dan
@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?
@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?
@danilang Facing this issue in my workflow rn.
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