prep replace
_DATE_NEW = DateTimeFormat([DATE],"%a") + ' ' + DateTimeFormat([DATE],"%d")
_DAT...
RightInputRows
Ignore
Mapped
_DATE_CROSSTAB
_DATE_NEW
replace colname
a
a
2019-01-03
2
b
b
2019-02-02
3
c
c
2018-01-01
4
d
d
2019-03-04
5
e
e
2018-03-03
6
e
e
2019-02-01
7
e
e
2012-01-01
8
e
e
2021-01-05
9
e
e
2013-03-10
10
e
e
2014-04-04
11
e
e
2019-01-02
12
Rename Date
Columns
_DATE_NEW = DateTimeFormat([DATE],"%a") + ' ' + DateTimeFormat([DATE],"%d")
dumm...
Basic
100%
*Unknown
Formula
Data
==
1
[id] = 'e' AND [_CurrentField_] IN ('0','1','2','3','4','5','6','7','8','9')
*Unknown Rule 1
Total
Always
Data
==
1
1
Total Rule 1
Sun 01
Formula
Data
==
1
[id] = 'e' AND [Sun 01] IN ('0','1','2','3','4','5','6','7','8','9')
Sun 01 Rule 1
Sun 10
Formula
Data
==
1
[id] = 'e' AND [Sun 10] IN ('0','1','2','3','4','5','6','7','8','9')
Sun 10 Rule 1
Fri 04
Formula
Data
==
1
[id] = 'e' AND [Fri 04] IN ('0','1','2','3','4','5','6','7','8','9')
Fri 04 Rule 1
Mon 01
Formula
Data
==
1
[id] = 'e' AND [Mon 01] IN ('0','1','2','3','4','5','6','7','8','9')
Mon 01 Rule 1
Sat 03
Formula
Data
==
1
[id] = 'e' AND [Sat 03] IN ('0','1','2','3','4','5','6','7','8','9')
Sat 03 Rule 1
Wed 02
Formula
Data
==
1
[id] = 'e' AND [Wed 02] IN ('0','1','2','3','4','5','6','7','8','9')
Wed 02 Rule 1
Thu 03
Formula
Data
==
1
[id] = 'e' AND [Thu 03] IN ('0','1','2','3','4','5','6','7','8','9')
Thu 03 Rule 1
Fri 01
Formula
Data
==
1
[id] = 'e' AND [Fri 01] IN ('0','1','2','3','4','5','6','7','8','9')
Fri 01 Rule 1
Sat 02
Formula
Data
==
1
[id] = 'e' AND [Sat 02] IN ('0','1','2','3','4','5','6','7','8','9')
Sat 02 Rule 1
Mon 04
Formula
Data
==
1
[id] = 'e' AND [Mon 04] IN ('0','1','2','3','4','5','6','7','8','9')
Mon 04 Rule 1
Tue 05
Formula
Data
==
1
[id] = 'e' AND [Tue 05] IN ('0','1','2','3','4','5','6','7','8','9')
Tue 05 Rule 1
Formula for unknown fields:
highlight for ID = e and values less than 10
Basic Table
C:\Users\Robert\AppData\Local\Temp\Engine_4176_4a50076e312d45d3b461784c6d15b4ae_\Engine_9284_735138a5c1d84d049e51ce23aa730ff8_.yxdb
Single
Report
Numeric
[_CurrentField_]
dynamic tostring all numeric
[_CurrentField_]
Horizontal
Broken Table Tool - TryThis2