topic Soft Coding the Date in the Title in App Development

Soft Coding the Date in the Title

Tue, 16 Jun 2015 14:23:21 GMT

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.

Re: Soft Coding the Date in the Title

Fri, 19 Jun 2015 17:15:24 GMT

Hello,

Try: 'Revenue (' & Month

Bye,

Estela

Re: Soft Coding the Date in the Title

Anonymous — Fri, 19 Jun 2015 17:26:01 GMT

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

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

Re: Soft Coding the Date in the Title

Fri, 19 Jun 2015 18:22:55 GMT

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).

Re: Soft Coding the Date in the Title

Anonymous — Fri, 19 Jun 2015 18:29:28 GMT

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.

Re: Soft Coding the Date in the Title

maxgro — Fri, 19 Jun 2015 18:36:12 GMT

maybe

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

Re: Soft Coding the Date in the Title

Fri, 19 Jun 2015 18:44:09 GMT

Hmm, for some reason this only returns

Revenue ()

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

Re: Soft Coding the Date in the Title

Anonymous — Fri, 19 Jun 2015 18:46:37 GMT

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?

Re: Soft Coding the Date in the Title

Fri, 19 Jun 2015 18:48:33 GMT

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

Re: Soft Coding the Date in the Title

Anonymous — Fri, 19 Jun 2015 18:53:43 GMT

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

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

Re: Soft Coding the Date in the Title

Fri, 19 Jun 2015 18:55:27 GMT

That works! Thanks!