Hi all,
I'm working on a dashboard to help with prospect campaign management and one metric my team would find useful is the number of plans with zero open/incomplete steps. The idea is to use an indicator widget and jump-to a pivot table so we can see who those prospects are.
I've gotten as far as (Count(Plan ID),[Step Completed]) with the filter showing incomplete steps, which is correctly showing how many plans have incomplete steps. But I'm not sure how to get a count of the plans that do not meet that criteria. Any ideas?
Thanks!
Sophie
This may sound like a cheat but how about subtracting that from the Count([Plan ID]) unfiltered?
count([Plan ID]) - ( count([Plan ID]) , [Step Completed] )
Thanks, Heath! That works for getting the number of plans without incomplete steps. Feeling silly for not thinking of basic math :) Unfortunately my jump-to dashboard is still reading the filter as "plans with incomplete steps". Do you think there is an easy way to get a list that shows the inverse?