Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
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
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])
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?
They are in the same table from the same source, so I don't think that would be the issue.
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
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])
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])