Count of days in timeframe

[#1]

I have a line chart with dimensions for Person and a date cyclic group which shows the day, week, month, etc.  I want to create an expression to calculate the number of days within the timeframe.  So if I select week for the date cyclic group, the number of days should be 7.  Started with COUNTNUMERIC ({1} Days).  This works and counts the days where the person has a value/data.  However, I want to count all days regardless if the Person has a value/data for that day.

[#2]

I'm not sure I understand your question.  Could you post a sample, picture or a little more detail?

Are you trying to count the number of days in a specific month?

     -ie Feb would be 28 except every fourth year it would be 29

Or are you trying to keep it generic a day=1, week =7, month =30 etc...

I would love to help but I am not sure I understand.

[#3]

are you trying to achieve the equivalent of DATEDIFF() in SQL context?

[#4]

Count the number of days in the specific month, so 28, 29, 30 or 31.

[wallinpeter]

Tough to answer with knowing how you modeled your data.

Have you tried.....

COUNTNUMERIC (TOTAL Days)

or

COUNTNUMERIC (TOTAL DISTINCT Days)

[#6]

The file is likely too big to load. When I use the total or total distinct it adds the days across all the people. so 30 *10 people , it would say 300 days

[wallinpeter]

try....

COUNTNUMERIC (TOTAL<Person> Days)