We use Cases to manage product installations.
I am trying to create a dashboard that shows average time spent in each possible Status by all of the installations (cases) closed in each calendar quarter.
i have been able to create my two groupings using a plain bar graph, but cannot figure out if there is a way to use report charts that will show a stacked bar graph of time spent in our various statuses under my two groupings.
The two groupings I want are shown in the first screencap. The first grouping is the calendar quarter in which the installation was closed as completed, and the second grouping is whether the installation was interfaced or stand-alone.
The stacked bar I would like to show for each of those groupings contains the average time spent in each status, as shown in the second screencap.
Is it possible to combine these two elements - perhaps through report charts? I have spent many hours experimenting without success. Any and all help appreciated! Thanks.
1 answer
I dont think its available for Stacked bars, once you convert from bar to stacked the second Y Axis options is not available.
