topic Re: Condition to show hide based on sequential Month selection in App Development

Condition to show hide based on sequential Month selection

Bala_s — Fri, 31 Mar 2023 05:19:23 GMT

Hi Experts,

I'm facing difficulty to get a solution for my below requirement, Request your expertise here.

Thanks in advance.

Scenario: I have Monthly sales in a bar chart, if the user selects nonsequential order of month then my chart should show an error message.

Ex--> User may select--> Jan, Mar, Nov etc

if user selects sequential order of month then my chart should display the numbers.

Ex--> User may select--> Sep, Oct, Nov

Thanks

Re: Condition to show hide based on sequential Month selection

Bala_s — Fri, 31 Mar 2023 07:41:21 GMT

Hi @tresB , @swuehl , @marcus_sommer

Any inputs from you pls?

Thanks

Re: Condition to show hide based on sequential Month selection

marcus_sommer — Fri, 31 Mar 2023 09:22:39 GMT

You may use a condition like:

= (max(Month) - min(Month) + 1) = count(distinct Month)

Of course Month needs to be numeric. If year-swaps should be included you would need to apply the logic on a continuous MonthCounter.

Beside this it might be more user-friendly not to show errors else to show always a continuous row of months - maybe with a set analysis like:

sum({< Month = {">=$(=min(Month))<=$(=max(Month))"}>} Value)

Re: Condition to show hide based on sequential Month selection

jmartineze — Fri, 31 Mar 2023 09:29:12 GMT

hi,

in data handling, calculation condition, you can use

num(min(month))+GetSelectedCount(month)-1=num(max(month))

Re: Condition to show hide based on sequential Month selection

Bala_s — Mon, 03 Apr 2023 02:54:40 GMT

Thanks a lot @marcus_sommer & @jmartineze

Re: Condition to show hide based on sequential Month selection

rajeshwar1 — Fri, 05 Apr 2024 22:26:16 GMT

Hi Marcus,

Can you tell what will be the expression if Month-Years are there?

Re: Condition to show hide based on sequential Month selection

marcus_sommer — Sat, 06 Apr 2024 07:25:33 GMT

It's in general the same. Important is that the fields are numeric. You may use any kinds of strings or formatted values within the dimensions or selections but if you want to match or calculate with them it should be pure numbers. For MonthYear these fields might be created with:

year(Date) * 100 + month(Date)

and/or

year(Date) * 12 + month(Date)