topic Re: Active selection in set analysis in App Development

Active selection in set analysis

jmialoundama — Wed, 22 Mar 2023 16:13:57 GMT

Hello,

I have the following set analysis which shows me a chart :

=Count({$<periode_id = {'$(=Max([periode_id]))'}>} distinct Key)

I want the graph to display by default on the last week without the user needing to select the week in the filters.

I also want the chart to show when the user wants to analyze a week.

How do I modify my set analysis?

Thanks in advance 🙂

Re: Active selection in set analysis

Benoit_C — Thu, 23 Mar 2023 10:00:11 GMT

Hello @jmialoundama,

If you want to allow the user to analyze a specific week by selecting a value for periode_id in a filter, you could try this:

=Count({$<periode_id = {"$(=Max({1} periode_id))"}>} DISTINCT Key)

Normally if no selection is made in the periode_id field, the chart will display data for the last week. However, if a selection is made in the periode_id field, then only data for that selected week will be displayed.

Is that working ?

Regards,
Benoit

Re: Active selection in set analysis

jmialoundama — Wed, 29 Mar 2023 08:16:20 GMT

Hi @Benoit_C ,

I test this solution but it's not works.

Finally, I put a condition on my graph. That is, the graph does not display until users select a week