Spotlight on the ADX Time Pivot Visualization
The Time Pivot chart is a powerful interactive navigation tool that lets you analyze your data over an events timeline, that pivots on a time axis. Time Pivot makes it easy to identify event flows, and beautifully tells the story of “what happened”. It helps you to generate multiple views of the same data by letting you pick multiple levels of data slicing. Time Pivot visualization is your essential tool for analyzing data across hundreds of different tables.
Query based pie charts in Azure DevOps - how do I display a percentage rather than a count?
Hi, I created several charts to track the progress of bugs and test cases. I will use the following two as examples: 1. Open Bugs by State: please reference attached - this chart shows the count of open bugs in each state. 2. Test Case Results by State: please reference attached - this chart shows all the test cases created, pivoted by state. Is there a way to display percentages for each pie slice, rather than the count? For example, in the Open Bugs by State, rather than showing Open = 18, can I display "72%" (18/25)? Right now when I configure the chart, I see the "Aggregation" option, but this only allows me to choose "Count". Do I need to update my queries somehow to get a %? Thank you for the assistance!
Donut/Doughnut Chart - Multiple Series
I have created a doughnut chart with multiple series (represented by multiple rings - see charts below). Each ring is divided into 6, the colour of which corresponds to one of three options (yes, maybe and no). I therefore want the colour of the chart to represent this clearly (green, yellow and red), making each ring comparable - i.e. so that the entire chart is made up of only three colours. When I format the legend entry to edit the colours, it only applies the changes to the inner ring/the first series. I am able to manually edit the colour of every other ring segment, however with a lot more data to add this will take a very long time and mean that I am no able to easily edit it should I wish to change the colour again. I imagine there is a way to do this in one simple step, however am unable to find it. Does this make sense? Any help would be greatly appreciated. Please let me know if I need to make this clearer/explin further. Thanks! Chart 1 - the automatically generated chart where only the colours of the inner ring have changed as I have edited them. Chart 2 - I have manually edited this chart to show how I want the chart to look - i.e. I want any colours that I change to apply to all series
Error in Excel : All the charts are removed
When i open any excel file that contains charts, I am getting an error that there is problem found in the file and if i want to restore the file. If i say yes, it removes all my charts in the excel file. I could not add any new chart to the excel (also in complete new excel sheet). I tried repairing it and I tried reinstalling it. that does not solve the problem. I did not had this issue before. I have attached pictures regarding this Issue? How can i solve it? I am using Excel 2016 Thanks in advance.
