Hi,

Is it possible to use Chart filters on custom computed properties? Or better yet, is there any kind of support for variables?

I have a Schema similar to:

{
  NestedArrayA: [ { ProjectNumber: "1" }, { ProjectNumber: "2" } ],
  NestedArrayB: [ { ProjectNumber: "2" }, { ProjectNumber: "6" } ]
}

I need to create charts that summarise the number of documents matching a ProjectNumber in either (and in both) collections so I can’t use a filter as that would force matching one or both.

Is there any way to define a custom filter/variable for “ProjectNumber” that I can use in the chart queries?

Thanks for your reply @tomhollander.

I might be missing something here. I’ve added a computed field AllProjectNumbers to an individual Chart with the aggregation:

{
    $setUnion: [
      "$NestedArrayA.ProjectNumber",
      "$NestedArrayB.ProjectNumber"
    ],
  }

When I try to add a Dashboard filter- I might not have been clear it was a dashboard filter I want to add. My computed field itsn’t an option and I have no option to add “missing” fields.

image529×593 12.5 KB

The reason I’d like to use a Dashboard filter is to allow users of the Dashboard to select a Project Number to be used in a number of charts.