Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have the following expression, I get no errors and it returns results.
The problem is the times, how should I be writing this with Set Analysis, I should see only transactions between 07:30 and 17:30, but with the below expression it shows all times for the max date
NUM(
SUM(
{<
Date = {"$(=MAX(Date))"},
[TrxType] = {'D'},
ActionID = {'PICKCASE'},
OneMinBucket = {"$(= '>=' & '07:30' & '<=' & '17:30')"},
OperativeName = {"=SUM($(metric2)) <> 0"}
>}
$(metric2))
,'#,##0')
If I have the following in a text object it returns the correct results
=concat({<Date = {'28/02/2017'},OneMinBucket = {"$(= '>=' & '07:30' & '<=' & '08:30')"}>}OneMinBucket,',')
So it works in text box, but not in a chart? That's strange, would you be able to share a sample?
Unfortunately I can't share the Application
Screenshots?
Apologies, it does work, the issue I have is with something else.
I need to display all times between 07:30 and 17:30 regardless of a transaction happening with each OneMinuteBucket.
I need to limit my dimension to show all minutes between the 2 times
I am not sure I am understanding anything Alan.... If you are able to neither share a sample or sample data or something else that I can understand... then I would let someone else help you out
Best,
Sunny
Does this work on the ListBox?
'>=07:30<=17:30'
if it works in your listbox, then it should work in set analysis as well
NUM(
SUM(
{<
Date = {"$(=MAX(Date))"},
[TrxType] = {'D'},
ActionID = {'PICKCASE'},
OneMinBucket = {">=07:30<=17:30"},
OperativeName = {"=SUM($(metric2)) <> 0"}
>}
$(metric2))
,'#,##0')