Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
In a straight table, I have customer as dimension, and in expression I want to count how many weeks that a customer has participated on both Tuesday and Friday in any given week. I'm using this set analysis
=count({<WeekStart=p({<WeekDay={'Fri'}>})*p({<WeekDay={'Tue'}>})>}distinct WeekStart)
Is there something wrong with this set analysis? Because it's showing an incorrect number.
You would need to bring in the customer in your set expression.
Create a key in your data model that is made of CustomerID and Weekstart, CustomerIDWeekstart.
=count({<CustomerIDWeekstart = p({<WeekDay={'Fri'}>})*p({<WeekDay={'Tue'}>})>} distinct CustomerIDWeekstart)
seems correct to me, try below
count({<WeekDay={'Fri'}>*<WeekDay={'Tue'}>} distinct WeekStart)
You would need to bring in the customer in your set expression.
Create a key in your data model that is made of CustomerID and Weekstart, CustomerIDWeekstart.
=count({<CustomerIDWeekstart = p({<WeekDay={'Fri'}>})*p({<WeekDay={'Tue'}>})>} distinct CustomerIDWeekstart)
Hi Sifat, try this
=count({<WeekStart=p({<WeekDay={'Fri'}*{'Tue'}>})>}distinct WeekStart)
Regards