Active selection in set analysis

[jmialoundama]

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 🙂

[Benoit_C]

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

[jmialoundama · Accepted solution]

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