topic Re: Excluding values on one specific graph in a sheet in App Development

Excluding values on one specific graph in a sheet

restrep101 — Tue, 29 Mar 2022 15:56:23 GMT

I have a bar graph in a sheet that has the following categories as a dimension (apple, banana, starfruit, and grapefruit) I want to remove apple and banana from the graph but not from the other graphs on the sheet. I have tried:

{<FruitName={'starfruit','grapefruit'}>}

which is auto-generated by the set expressions and a bookmark I created. But then I get an error message:

Error in expression

garbage after expression:'='

{<FruitName={'starfruit','grapefruit'}>}

How can I exclude values or dimensions on one graph?

Re: Excluding values on one specific graph in a sheet

Or — Tue, 29 Mar 2022 16:06:16 GMT

That needs to go inside an aggregation function, e.g.

Count({<FruitName={'starfruit','grapefruit'}>} FruitName)

Re: Excluding values on one specific graph in a sheet

restrep101 — Tue, 29 Mar 2022 16:19:36 GMT

Thank you! there is no error code anymore but now when I get out of the expression editor it states that it is an invalid dimension

Re: Excluding values on one specific graph in a sheet

Or — Tue, 29 Mar 2022 20:16:20 GMT

It should be a measure...