topic Re: Calculate the sum of the current month in Visualization and Usability

Calculate the sum of the current month

Anonymous — Thu, 17 May 2018 19:26:47 GMT

I need to calculate the sum of the current month:

Variable vCurrent_Month:

=Month(Today())

Sum({< Month_date = {"$(vCurrent_Month)"}>} Visitors)

Re: Calculate the sum of the current month

Anonymous — Thu, 17 May 2018 21:25:51 GMT

=Month(Today()) is just going to give you 'May' as a result.

=Date(Today(),'MMM-YYYY') will give you the current month, just match the format string to month_Datesyntax. The syntax is val

Edit: I've seen a lot of posts here recommending new syntax. The syntax is valid, I worked it on my device. It's the output of the variable that's not matching whats in your dimension.

Andrew

Re: Calculate the sum of the current month

adityaakshaya — Thu, 17 May 2018 21:33:39 GMT

Hi Gustavo,

Please use like below

Variable vCurrent_Month:

Month(Today())

Remove "=" before Month().

sum({<Month_date ={'$(=$(vCurrent_Month))'}>}Visitors)

Regards,

Akshaya

Re: Calculate the sum of the current month

jolivares — Fri, 18 May 2018 01:09:37 GMT

You may use Num(Month(Today())) = 5

Re: Calculate the sum of the current month

agigliotti — Fri, 18 May 2018 07:21:29 GMT

you can use the below expression:

Sum( {< Month_date = {"=Month(Today())"} >} Visitors )

Hope it helps.