After changing the value in the Analysis screen Display dropdown, changing the Data > Category dropdown can result in a non-existent item showing in an Aggregation dropdown. The result is an error message.

For example, when switching from Objectives to Audits, changing the Data > Category dropdown to Lead Auditor could leave you with an Aggregation of Objective Attachment - an item which doesn't exist against audits.

The result is an error: InvalidQuery: Property Objective.AttachmentCount does not match the perspective Audit:

Universal Time: (2021-09-18 08:39:08) Local Time: (2021-09-18 09:39:08) TimeZone: (01:00:00 DST)
Version: 6.0.1.0
EXCEPTION: TargetInvocationException

message: An exception occurred during the operation, making the result invalid. Check InnerException for exception details.
source: System
target: Void RaiseExceptionIfNecessary()
stack: at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
at Pentana.Tng.UI.Smart.Common.Chart.CreateChart_RunWorkerCompleted(Object sender, RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.OnRunWorkerCompleted(RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.AsyncOperationCompleted(Object arg)
at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)


EXCEPTION: TngException[General]

message: The application generated an invalid query. See Errors for details
source: Pentana.Tng.Agent.Smart
target: Pentana.Tng.Messaging.ResponseMessage`1[Pentana.Tng.Messaging.QueryResult] ExecuteQueries(Pentana.Tng.Messaging.RequestMessage`1[Pentana.Tng.Messaging.Query])
query: 
<Query Perspective="Audit" ID="Audit" Type="Aggregate">
<Properties>
<Property Mid="Objective.AttachmentCount" ID="Aggregate" Aggregation="Average" />
<PropertyGroup Path="Audit.Leader" ID="Category1Audit.Leader" IncludeUid="true" />
</Properties>
</Query>
stack: at Pentana.Tng.Agent.ServiceBroker.ServiceBrokerInternal.ExecuteQueries(RequestMessage`1 request)
at Pentana.Tng.Agent.QueryExecutor.ExecuteQueries(IEnumerable`1 queries)
at Pentana.Tng.UI.Smart.Common.Chart.CreateChart_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

InvalidQuery: Property Objective.AttachmentCount does not match the perspective Audit

To work round this:

• At the error dialog, click Continue
• Finish setting the Data Category and Aggregation options
• Quit Ideagen Internal Audit (Aura) and reopen