prep replace
_DATE_NEW = DateTimeFormat([DATE],"%a") + ' ' + DateTimeFormat([DATE],"%d")
_DAT...
RightInputRows
Ignore
Mapped
_DATE_CROSSTAB
_DATE_NEW
replace colname
a
2019-01-03
2
b
2019-02-02
3
c
2018-01-01
4
d
2019-03-04
5
e
2018-03-03
6
e
2019-02-01
7
e
2012-01-01
8
e
2021-01-05
9
e
2013-03-10
10
e
2014-04-04
11
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 tonumber([_CurrentField_]) <10
*Unknown Rule 1
Sun 01
Formula
Data
==
1
[id] = 'e' AND tonumber([_CurrentField_]) <10
Sun 01 Rule 1
Sun 10
Formula
Data
==
1
[id] = 'e' AND tonumber([_CurrentField_]) <10
Sun 10 Rule 1
Fri 04
Formula
Data
==
1
[id] = 'e' AND tonumber([_CurrentField_]) <10
Fri 04 Rule 1
Mon 01
Formula
Data
==
1
[id] = 'e' AND tonumber([_CurrentField_]) <10
Mon 01 Rule 1
Sat 03
Formula
Data
==
1
[id] = 'e' AND tonumber([_CurrentField_]) <10
Sat 03 Rule 1
Wed 02
Formula
Data
==
1
[id] = 'e' AND tonumber([_CurrentField_]) <10
Wed 02 Rule 1
Sat 02
Formula
Data
==
1
[id] = 'e' AND tonumber([_CurrentField_]) <10
Sat 02 Rule 1
Fri 01
Formula
Data
==
1
[id] = 'e' AND tonumber([_CurrentField_]) <10
Fri 01 Rule 1
Total
Always
Data
==
1
1
Total Rule 1
Thu 03
Formula
Data
==
1
[id] = 'e' AND tonumber([_CurrentField_]) <10
Thu 03 Rule 1
Mon 04
Formula
Data
==
1
[id] = 'e' AND tonumber([_CurrentField_]) <10
Mon 04 Rule 1
Tue 05
Formula
Data
==
1
[id] = 'e' AND tonumber([_CurrentField_]) <10
Tue 05 Rule 1
Formula for unknown fields:
highlight for ID = e and values less than 10
Basic Table
C:\Users\michael.dyatchen-ptr\AppData\Local\Temp\Engine_13864_fe2d360cd96a407ea88bb43288e007c9_\Engine_11784_bfb438f8c2024f0a89b34b88ae49f97a_.yxdb
Single
Report
Horizontal
Broken Table Tool