Condition:
Cascading filter : Continent → Country → Code
Calculated Field 'TotalNumberOfOneCountry’Code: countOver(Index,[Continent,Country],PRE_FILTER)
Purpose:
1st line shows total number of index regarding selected Code(‘None’ in this case) Per Day.
2nd Line shows total number of index in that country Per Day.
Problem:
TotalNumberOfOneCountry’Code only shows constant total across all days.
Hi @bagpacker,
Apologies on behalf of the community that your post was originally missed. A quick note on that, when you add a second comment to your post, it removes it from the ‘new’ and ‘unanswered’ sections so it’s possible that it could be missed, like this scenario. I would suggest for future references, that instead of adding an additional comment, just edit your original message instead so that it still shows as ‘New’!
In regards to your post, are you still running in to this situation or were you able to find a work around? To me it seems like the issue is stemming from the use of ‘PRE_FILTER’ as that negates your controls set on the visual. Have you tried using PRE_AGG instead?
Hi @bagpacker,
It’s been awhile since last communication on this thread, did you have any additional questions or were you able to find a work around for your case?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @bagpacker,
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.
Thank you!
