Soft Coding the Date in the Title

[#1]

Hi guys,

I have a bar chat with dimensions for "Month" (Jan, Feb, Mar, etc).

I would like to soft code the title to say: "Revenue (Current Month)"

Ex: "Revenue (June)"

And have it continuously update depending on the current month.

Is it possible to soft code it so it correlates with the data being shown?

Thanks for your help.

[#2]

Hello,

Try:  'Revenue (' & Month

Bye,

Estela

[Anonymous]

If I got the request right, it'll rather be

='Revenue (' & month(ReloadTime()) & ')'

[#4]

Where does this pull from? Is it pulling the actual current month? I actually want to pull it from the "Month" dimension from my data (which actually has May).

[Anonymous]

It's quite a different question.

ReloadTime() is a timestamp of the end of the last successful reload.  If it was in May, it returns May.

[maxgro]

maybe

='Revenue (' & date(max(Month), 'MMM') & ')'

[#7]

Hmm, for some reason this only returns

Revenue ()

With nothing inside the (). Month is a dimension though...

[Anonymous]

Probably you have it as text.

What's wrong with the last reload time?  How you decide that it should be May in your case?

[#9]

I'm running a dashboard that shows the latest closed month (in this case, it's May since June hasn't closed yet).

[Anonymous · Accepted solution]

Assuming that the month is "closed" when you move to the next month, you can use

month(monthend(reloadtime(),-1))