C:\Users\mmachen\Desktop\WIP\ALTERYX\TRACKING\Book1.xlsx|||`Sheet1$`
False
1
Input PowerBI report view
Book1.xlsx
Table=`Sheet1$`
Need to iterate
Email addreses
carrier
Carrier SCAC
Email
FindAny
Append
ADRW
testing@testing.com
ABCD
testing@testing.com
TODO
Make an input file SCAC and emails
NOTE
Separate multiple emails by semicolon
Unique: carrier, Email
Reporting
C:\Users\mmachen\AppData\Local\Temp\Engine_29824_fffa9364b9e14f5682208496151eebb2_\Engine_36332_bbae2e5597fb4f5ba57897ea212d1c4e_.yxdb
Single
Report
C:\Users\mmachen\AppData\Local\Temp\Engine_29824_fffa9364b9e14f5682208496151eebb2_\Engine_36332_33b201533a8f4e0d94d598c5ba660c81_.yxdb
Single
Report
Email
testing
Table
True
Can use a field as variable within email text.
This is a test body for the em...
Basic
100%
Basic Table
Warning
All
ByName
PerRecord
H
Continuous
100%
0
Horizontal Layout
Each Individual Record
Error
R graph
library(ggplot2)
AlteryxGraph(1, width=640, height=480)
AlteryxProgress(0.25)
df <- read.Alteryx("#1", mode="data.frame")
ggplot(data=df, aes(factor(week_of), Value, fill=Name, label=Value)) +
geom_bar(stat="identity") +
#geom_bar(stat="identity", position="dodge" ) +
scale_fill_brewer(palette = "Set1") +
geom_label(color="white", fontface="bold", position = position_stack(vjust = 0.5))
TO DO
Rename data labels
Finalize colors and formatting
C:\Users\mmachen\AppData\Local\Temp\Engine_29824_fffa9364b9e14f5682208496151eebb2_\Engine_36332_dd9ca13a53ed4ef198b103a9506269a8_.yxdb
Single
Report
Warn
Format and calc percents
Carrier - Ascending
DateTime_Out - Descending
First
8
First 8
Week_End
Mon dd yyyy
DateTime_Out
Convert Week_End From:
Custom
3_Untracked = IIF(IsNull([3_Untracked]), 0, [3_Untracked])
total = [1_Tracked_Wi...
Formatted carrier info with all percent inputs for R graph
Horizontal
tracking_test