topic Re: Not showing current month in App Development

Not showing current month

mtabernad — Sat, 16 Nov 2024 01:04:54 GMT

Hi all,

I want to show in a line chart the behavior of a KPI during the days of the current month. My expression is as follows:

=1+(

(count({$<flag_user={"$(='Sí')"},Month={"$(=max(Month))"},Year={"$(=max(Year))"}>}connect_time)
-
count({$<Month={"$(=max(Month))"},Year={"$(=max(Year))"}>}connect_time)

)
/
count({$<Month={"$(=max(Month))"},Year={"$(=max(Year))"}>}connect_time))

It works but only if a select the current month (november) in the filter pane, if not it shows up a blank.

Without filters:

November selected:

So I want this last chart to show up without any selections.

Could anyone help me?

Thank you in advance.

Re: Not showing current month

forte — Mon, 23 Nov 2020 12:56:00 GMT

Hi @mtabernad

It seems that you have value for December for "Month" field (may be due to master calendar).

Just try changing your expression with something like this (calculating current month through today function)

=1+(

(count({$<flag_user={"$(='Sí')"},Month={"$(=month(Today()))"},Year={"$(=year(Today()))"}>}connect_time)
-
count({$<Month={"$(=month(Today()))"},Year={"$(=year(Today()))"}>}connect_time)

)
/
count({$<Month={"$(=month(Today()))"},Year={"$(=year(Today()))"}>}connect_time))

Hope it helps

Regards

Re: Not showing current month

mtabernad — Mon, 23 Nov 2020 14:00:46 GMT

Great Forte! It works!

Good workaround.

Thank you for your help. Regards.