Calculate number of days in field or current selection

[Cap]

Hi all,

After several research on the subject in our community, i was unable to find a solution to my problem:

I use three filters on a SAP Dashboard : Year, Month, Quarter

I would like to get the number of days of the current selection using only expression so it's calculate in the front end(don't think there is a solution in back end)

Example:

the prospect select 2019 - Q1 - January -> 31 days
the prospect select 2020 - Q2  -> 91 days
The prospect select 2019 -> 365 days

Thanks in advance for your help, really tried to solve that on my own but i'm missing of knownledge with time function i think 😞

[brunobertels · Accepted solution]

Hi 

have a look to this function 

monthstart() and monthend() for Month 

quaterstart() and quarterend() for quarter 

yearstart() and yearend() 

To get the number of day try like this : 

monthend(DateField) - monthstart(DateField) and so on 

[MarcoWedel · Accepted solution]

Having a complete calendar implemented, you could just use

Count(Distinct Date)

to get the number of days matching your selections.

[Cap]

Thanks to both of you, the two solution are both interresting 👍👍 I now know how to work this.

Thank you so much