Allocated Memory Exceeded - Conditional Statement Issue?

[#1]

Hello,

I'm trying to get a Pie chart to show the data of incidents that were opened in the last 28 days, and are ranked level 1 and level 2. I have created a variable that measures the last 28 days. Below is my code for my expression, is this the reason I'm getting the error message?

Sum(
{<
[Incident Severity Code]={'1','2'},
[Incident Open Date]={'>=$(v28DaysBack)'}
>}
[Incident Counter])

Incident Counter is the number of all incidents, severity code is what level (so I only want level 1's and 2's) and the open date is when they were logged as open.

Speaking to the service manager the memory utilisation is at 60% so nothing to worry about on that front.

Thanks for the help,

Michael

[vishsaggi]

What is your expression in that variable can you post it please ?

May be you can try:

Sum( {< [Incident Severity Code]={'1','2'}, [Incident Open Date] =  {"$(= '>=' & Date([Incident Open Date], 'MM/DD/YYYY') -28) & '<=' & Date([Incident Open Date], 'MM/DD/YYYY'))" }  >} [Incident Counter])

[#3]

Hi Vish,

Below is the variable:

v28DaysBack: Date(Today()-28,'dd-MMM-YYYY')

I'll try what you've suggested anyway and it came up with "No data to display".

Thanks,
Michael

[vishsaggi]

Can you change your variable to this and try ?

IS your [Incident Open Date] has the same format as your variable date?

Sum(
{<
[Incident Severity Code]={'1','2'},
[Incident Open Date]={" $(= '>=' & '$(v28DaysBack)' & '<=' Date(Today(), 'dd-MMM-YYYY') )" }
>}
[Incident Counter])

[Colin-Albert]

The first thing I would check is the data model.

Do the fields you are using exist in separate tables that are not associated in the data model? If so then a Cartesian join is created in memory hence the out-of-memory error.

See this post for more details  Re: Why do unlinked tables consume excessive memory?

[#6]

They are in the same table from the same source, so I don't think that would be the issue.

[#7]

What did you need me to change my variable to? Or should I just change the expression to what you've listed as above?

Michael

[vishsaggi]

Sorry I mean can you try the below expression and see if you getting any values.

I presume the IncidentOpenDate is in the same date format 'dd-MMM-YYYY'.

Sum(
{<
[Incident Severity Code]={'1','2'},
[Incident Open Date]={" $(= '>=' & '$(v28DaysBack)' & '<=' Date(Today(), 'dd-MMM-YYYY') )" }
>}
[Incident Counter])

[jonathandienst]

First, define the variable slightly differently - add a leading = sign:

     Set v28DaysBack = =Date(Today()-28,'dd-MMM-YYYY');

     (not a typo, you could also add the = sign in the variable overview)

Then use the expression:

=Sum(

  {<

     [Incident Severity Code]={'1','2'},

     [Incident Open Date]={">=$(=v28DaysBack)"}

  >}

[Incident Counter])