Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts!
I have Date flags (MonthEndDateFlag={'1'}, LastMonthInYearFlag={'1'}) to determine the max(snapshots) in a year, month.
I have the below expression and it's only working when Year is selected in the cyclic group.
=Num(Count({$<Type={'A'}, MonthEndDateFlag={'1'}, LastMonthInYearFlag={'1'}>} Distinct CaseID),'#,##0')
What is the correct expression to enable these flags to work with the date cyclic group wherein i have days, week, month and year?
Thank you in advance.
In which chart you are trying? Not working means what? What does that flag means? From their names it looks like you are trying to filter Type 'A' cases in the last day of the year? Means it should show 0 for rest of the months and days?
A sample data or app should help to understand it further.
Thank you for your reply.
Please see attached file for the sample data. You'll find that when you select the month from the cyclic group, it would only show a month instead of 2 as there is Jan and also Feb months. The flag for the year is preventing this from happening.
What should be the right set analysis/expression to use to show all the months or weeks when selected month or week from the cyclic group?
Hi - As you can see in the below pic, you dont have any data for the month of Jan that satisfy the condition
MonthEndDateFlag={'1'} and LastMonthInYearFlag={'1'} but you have some data for feb.
Similarly you have some data for 2018 that satisfy MonthEndDateFlag={'1'}, LastMonthInYearFlag={'1'}
Krishna,
There isn't suppose to be any data for LastMonthInYearFlag for Jan as it is not the Last Month for the current year. The expectation is that there should be 2 bars representing the 2 months. What modification do i need in the expression to show that?