topic Display only some information in a Line Chart but add information with filters when I want in App Development

Display only some information in a Line Chart but add information with filters when I want

Manuel174102 — Tue, 09 Aug 2022 09:29:13 GMT

Hello everyone

So I have a line chart which is displaying information of 7 categories.

I only want to display at all times the information of two of them, but I want to be able to add the other categories when I want, through a filter. How could I do that?

The field name is Order Type, and the categories I want to show are Service and Delivery.

thanks

Re: Display only some information in a Line Chart but add information with filters when I want

Mark_Little — Tue, 16 Aug 2022 15:00:23 GMT

HI @Manuel174102

I would use an if Statement.

IF(GetSelectedCount( Order Type]) = 0

SUM({<[Order Type}= {'1','2'}>}SALES),

SUM(SALES))

Re: Display only some information in a Line Chart but add information with filters when I want

Mario_De_Felipe — Fri, 19 Aug 2022 07:51:55 GMT

You could use a variable to store the values you want to filter in the [Order Type] Field.

vOrderType = chr(39) & Concat([Order Type],chr(39) & ','& chr(39)) & chr(39)

And the expression in the line chart would be:

SUM({<[OrderType]={$(vOrderType),'Service ','Delivery'}>} Sales)

Re: Display only some information in a Line Chart but add information with filters when I want

Manuel174102 — Mon, 22 Aug 2022 08:26:22 GMT

thanks!