How can I display 3 levels of information on a line chart's x-axis like what excel can do
Many of the engineers in my organization is using the pivot tables to create charts in Excel. Often, the charts will have 2 or 3 levels of information on the X-axis (see attached image with 3 levels of info). I can't find a charting feature or method in QS to do the same. Appreciate the community's help with a solution.
Hi Quy, I experimented with the drill down dimension and while it can do as per what the video described, it did not achieve what the Excel Pivot chart with 3 levels of info on the X-axis can give to the analysts. By drill in, I can see info at the breadcrumb level but not at the breadload level. Also the drill down can only apply to a single selection. Let's say I have the production lot measure data for every month from 2017-2019. The Excel pivot chart will be able to display each production lot's measure from 2017-2019 so we can see how we are doing for each month and a very quick comparison month on month, year on year, lot on lot or at which month after countermeasure implementation that there was a step improvement of the measure. For the drill down dimension approach, I can only select 1 year, drill down to the months, select 1 month before I can see the production lot for the month. I cannot select 2 years and drill down further. Any alternative suggestion?