Condition to show hide based on sequential Month selection

[Bala_s]

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

[Bala_s]

Hi @tresesco , @swuehl , @marcus_sommer 

Any inputs from you pls?

Thanks

[marcus_sommer · Accepted solution]

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)

[jmartineze]

hi,

in data handling, calculation condition, you can use

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

[Bala_s]

Thanks a lot  @marcus_sommer  & @jmartineze 

[rajeshwar1]

Hi Marcus,

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

[marcus_sommer]

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)