I have a chart that is displaying data from employee reviews done both by the employee and their supervisor. There are different categories they are being scored on like:
“Knowledge: Understands job functions, requirements, tools/equipment, and processes associated with this position.” and “Execution: The ability to ‘get things done’. Follows through on task until completion, in a timely manner according to schedule. Overcomes obstacles, proposes solutions rather than excuses.”
The long descriptions are needed in the form and in the detail view but are obviously not helpful in a chart and I’m just wanting title word. I haven’t been able to get this combination to work. Any CONTEXT(“ViewType”) formulas I try have just led to it showing one or the other in every view type. I think part of why it isn’t working is because I also have both of these views in a dashboard. The closest I’ve gotten is this:
IF(OR(CONTEXT(“ViewType”)=Form, CONTEXT(“ViewType”)=Detail), “Process Improvement: Improves existing processes to either increase productivity, quality, or customer satisfaction.”, “Process Improvement”)
But with this, the Detail view in my dashboard still shows the short version. If I expand the detail view it will switch to the full version. But I can’t use ViewType as Dashboard or it makes them long on the graph too. Is there any way to do what I’m wanting to do?