Alteryx Designer Desktop Discussions

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

Display Measurement Data and Bar Chart in Excel File (Workflow attached)

kal-tech
8 - Asteroid

Hi

 

Display  data and bar chart in an excel file for each agency

 

Supplied : Workflow, Input Data file  , Output File file containing  Bar chart

 

C:\temp\Input-File \ HVC Raw Data-Test.xlsx

C:\temp\Output-File\ ABC Corp.xlsx

                                              COE CORP.xlsx

                                              Bar Chart-ABC Corp.xlsx

 

Workflow : WorkflowCampaign-Test.yxwz

 

  1. When you run the workflow it takes data from the input file and creates two files
  • C:\temp\Output-File \ABC Corp.xlsx  (See ABC CORP File Below)
  • C:\temp\Output-File \COE CORP.xlsx

 

Agency

Year-Month

Project Count

Sum_Pass

Sum_Fail

Sum_SS

Agency Score Percent

ABC Corp

2024/05

3

23

 

 

100%

ABC Corp

2024/04

4

4

9

1

81%

ABC Corp

2024/03

4

 

 

 

100%

ABC Corp

2024/02

4

 

 

 

100%

ABC Corp

2024/01

4

 

 

 

100%

ABC Corp

2023/10

4

2

 

 

88%

ABC Corp

2023/08

1

2

3

 

95%

ABC Corp

2023/07

3

2

8

3

83%

ABC Corp

2023/05

2

 

 

 

100%

ABC Corp

2023/04

4

 

 

 

100%

ABC Corp

2023/03

4

6

20

 

82%

ABC Corp

2023/02

4

14

23

3

89%

ABC Corp

2023/01

4

 

 

 

100%

 

  1. Take output file ABC Corp.xlsx . Put the above data grid and below bar chart in a excel file .

kaltech_0-1722628157277.png

 

 

Issues :

  1. The bar chart is not showing all month’s data in the X-Axis and legends number of Measurements
  2. Can we omit #2 above and directly create aggregate data and Bar chart at the same time by agency and save the excel file.

Is there any suggestion how to display aggregated data and bar chart at the same time in the excel file.

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@kal-tech 
I did not quite understand your 2nd question, but for 1st one, I made some adjustment on the X, Y Axis setting and insert a Sorting tool, now it looks alright.

0803-kal-tech.png

kal-tech
8 - Asteroid

Hi Qiu:

 

Thank you for attempting to address the issue.

 

I add a filter condition to display all rows in the chart that have pass, fail and SS > 0 and add the filter condition descending. I also keep your suggestion  X-Axis Min = 0 and MAX = 18.  I can see Bar chart now.

 

 

 

kaltech_0-1722706657175.png

 

Issue #1 : The Legends values  are not showing for Tall Bars.

Issue #2  : I want the 2024/05 Pass, Fail, and SS bar numbers to show, followed by some spaces, and then the 2024/04 bar numbers to display. The Layer --> ‘Bar mode = Group’ is grouping the bars together, which is good. How can I increase the spaces between the X-Axis dates at the bottom?

kaltech_1-1722706657177.png

 

 

Issue#3 : I am running two workflows: one to populate the data for the bar chart, and then a second workflow to input data from the first workflow to populate the bar chart in Excel. Can we run a single workflow to show the data & bar chart both in Excel ?

Labels