Month Name in Data View Block Title Without Time Axis
I have a data view which needs data entry for a particular month, but I also want to display a trend of data leading to the current month.
This is simple enough using the Period Offset function and selecting only the month that is needed for data entry, however, I then cannot put months in the column axis and hence cannot display the month name in the title of the column.
My work around at the moment is to rename the block PM for Prior Month, PM-2 for two months ago, etc. But this is less than ideal.
Any way to get this to work?
Answers
-
Dear Mark Schad,
thanks for your request.
For general you can also solve with all Months to show selected and the month by row.
You just have to insert another Lock Cube which denies the dataentry for all other months except for the actual one.
The DataView function to use is called "Locked By" Other data functions .
The Lock Cube must have values for each Month where no data should be inserted and for the "active" one it has to be zero.
I think this will be the easiest way to get your solution.
Hope it helps
regards
Alexander Kappes
1
Categories
- All Categories
- 1.9K Forums
- 1.8K Platform
- 153 Academy
- 314 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 47 How-To Guides
- 19 Board Advocacy Program
- 184 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 335 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP