Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Assuming that the month is "closed" when you move to the next month, you can use
month(monthend(reloadtime(),-1))
Hello,
Try: 'Revenue (' & Month
Bye,
Estela
If I got the request right, it'll rather be
='Revenue (' & month(ReloadTime()) & ')'
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).
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.
maybe
='Revenue (' & date(max(Month), 'MMM') & ')'
Hmm, for some reason this only returns
Revenue ()
With nothing inside the (). Month is a dimension though...
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?
I'm running a dashboard that shows the latest closed month (in this case, it's May since June hasn't closed yet).
Assuming that the month is "closed" when you move to the next month, you can use
month(monthend(reloadtime(),-1))