Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I select a Week in my document, the number of days in that week are highlighted only if there is data for those days. For example, a week has seven days but if my selection only contains data for 6 days, the count is 6. I want to be able to count the number of calendar days in a selection, regardless of presence of data. So, if I select a month I want to count 30, 31, or 28 days. Even if there are days missing data.
Can I do that?
Brian Summ
Haven’t tried it yet. Thanks though.
Hi Brian.
It depends on the schema you have created. Do you have a Calendar Table?
If you have it, you could count (distinct Date_Field)
If you don't have it, try with
max(Date_Field)-min(Date_Field)
Date_Field must be in date format, not timestamp.
Hi Sebastian,
Thanks for the help. I have tried the count function. Trouble is it only counts selected days if there is data. I want to count all selected days, regardless of presence of data.
Regards,
Brian
You must create a Calendar table and use Set analysis at MIn and Max function. Like that: max({1<week=,week={$(#=only(week))}>} date)
Did you have tried the second suggest i sent?
Please, read all!
max(Date_Field)-min(Date_Field)
Haven’t tried it yet. Thanks though.