Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is very odd - I built a set analysis chart and it was working great. Then after a manual reload it stopped working. You can see below with the highlighted examples, that I can get "40187" to work so long I don't do any "math" against it -
Works and evaluates --
=Sum ({$<[DFA_Search.DayNumber]={$(=Only(DFA_Search.DayNumber))}>}if(DFA_Search_Spotlight.Group='DSL Order' or DFA_Search_Spotlight.Group='FiOS Data' or DFA_Search_Spotlight.Group='FiOS TV', DFA_Search_Spotlight.SpotlightTagValue, 0))
Doesn't work (but I am pretty sure it was at some point)
=Sum ({$<[DFA_Search.DayNumber]={$(=only(DFA_Search.DayNumber)-1)}>}if(DFA_Search_Spotlight.Group='DSL Order' or DFA_Search_Spotlight.Group='FiOS Data' or DFA_Search_Spotlight.Group='FiOS TV', DFA_Search_Spotlight.SpotlightTagValue, 0))
DFA_Search.DayNumber is defined as --
NUM
(ReportDate) AS 'DayNumber',
Keyword
=Sum ({$<[DFA_Search.DayNumber]={40187}>}if(DFA_Search_Spotlight.Group='DSL Order' or DFA_Search_Spotlight.Group='FiOS Data' or DFA_Search_Spotlight.Group='FiOS TV', DFA_Search_Spotlight.SpotlightTagValue, 0))
=Sum ({$<[DFA_Search.DayNumber]={40186}>}if(DFA_Search_Spotlight.Group='DSL Order' or DFA_Search_Spotlight.Group='FiOS Data' or DFA_Search_Spotlight.Group='FiOS TV', DFA_Search_Spotlight.SpotlightTagValue, 0))
391
0
foo
5
1
2
verses
=Sum ({$<[DFA_Search.DayNumber]={40185}>}if(DFA_Search_Spotlight.Group='DSL Order' or DFA_Search_Spotlight.Group='FiOS Data' or DFA_Search_Spotlight.Group='FiOS TV', DFA_Search_Spotlight.SpotlightTagValue, 0))
466
4
Does anyone have any ideas on if my syntax is wrong or if I am missing something.
Thanks,
Chris