Set Analysis with Times

[rustyfishbones]

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,',')

[sunny_talwar]

So it works in text box, but not in a chart? That's strange, would you be able to share a sample?

[rustyfishbones]

Unfortunately I can't share the Application

[sunny_talwar]

Screenshots?

[rustyfishbones]

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

[sunny_talwar]

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

[vinieme12]

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')