Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to omit the total from the settings entered for visual clues on a graph?
I have a word screen shot of my graph to show what I mean.
instead of visual cues use text color and background color of the expression in expression tab
dimensionality for get normal or total rows
example, for background color of VacantDays (label)
=if(Dimensionality()>0,
if(VacantDays>=10,Green(),
if(VacantDays>-0.01,Yellow(),
yellow()
))
,
black()
)
On Expressions tab > remove Total (lower right of window); otherwise - consider coloring fields using background color with a conditional coloring scheme.
Thanks Greg - I want the total to show - I just don't want the visual cue settings to apply to it so removing the total isn't an option.
Anthony - Use Expression > Background Colour instead of Visual Cues.
Not quite familiar with that Deepak - could you give an example of the definition you would use to say make the cell background green for values above 5?
I have made a video tutorial sometime back. Please see the below tutorial:
Thanks,
DV
instead of visual cues use text color and background color of the expression in expression tab
dimensionality for get normal or total rows
example, for background color of VacantDays (label)
=if(Dimensionality()>0,
if(VacantDays>=10,Green(),
if(VacantDays>-0.01,Yellow(),
yellow()
))
,
black()
)