How To Create Set Analysis To Count A Distinct Text Based On The Date Condition
Hello Experts,
I'm still learning! I'm trying to create a set analysis by counting a distinct text after a date range. Below is a dummy data to use as an example. I want to count column [CoDoc],'9C', after Oct/18/2021.
You can also check adding [Date Receive] to a table or ilter object. If it's right-aligned it's ok, if it's lef-aligned that means that it's being loaded as a text, not a dte, and comparing with >= won't work until it's converted to a date.
I used the syntax you provided for '9C,' and the count of (1) is correct on my actual. But, the same syntax for another distinct ('6R') count also counts as 1, which should be 20. Could I be missing something? Any suggestions you may have to correct this will help? Thank you.
Hi, now that you say... If you have a set analysis that filters only one value of CoDoc, and you count the distinct values of Codoc... if will always return 1 (or 0).
Try removing the "distinct". Or maybe you want to count another field, not the same CoDoc field that is used on set analysis.
Thank you for responding! When I remove the the distinct function, Count({<[CoDoc]={'9C'},[Date Receive]={">=14/9/2021"}>}[CoDoc]), it counted all of the 9C and not by the date criteria. I need the syntax to count all the CoDoc after or before a certain date. Thank you.
You can also check adding [Date Receive] to a table or ilter object. If it's right-aligned it's ok, if it's lef-aligned that means that it's being loaded as a text, not a dte, and comparing with >= won't work until it's converted to a date.
