I have created a parameter ’ Subscriber’ based on a field called ‘Sub flag’ .
Sub flag has 2 values : Store purchaser, Subscriber purchaser.
If the user select subscriber, it should show all rows with sub flag ‘Subscriber purchaser.’
and if user select subsctiber , it should all rows with sub flag ‘Store purchaser’.
If user selects select all, it should all rows .
This is the calculated fiield for showing the users,. if the customer purchases within purchase start and ourchase end and if the subscriber flag matches the parameter, it should show user id.
Converted customers :
ifelse(
{Time_to_Purchase} >= ${Purchasestart} and {Time_to_Purchase} <=${Purchaseend} and {Sub_flag} = ${Subscriber},userID,NULL).
The issue if if i am selecting ‘Select all from the drop down’, it shows 0 records.
It shows records if I am selecting store purchaser or subscriber purchaser
Assuming ‘Converted’ is some kind of seller code and not the count of ‘UserID’, and your ifelse statement is for the converted_sub, can you post screenshots of what the output is when you select either ‘store purchaser’ or ‘subscriber purchaser’. Like to see if single or multiple UserIDs are displayed per ‘Converted’ before seeing what’s happening with select all. Thanks!
I suggest you use a Sub_Flag condition from the calculation field, apply it as a filter and show the Converted and Converted_Sub as two separate visuals. That is an option.
Hi @liya101,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
