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!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.
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.Chart from a calendar
I'm just starting on my SharePoint journey. I'd like to put a calendar of events I've got booked on my site, which is fairly simple, I've worked that much out. Below this I'd like to put a column chart showing how many events I've got booked in each month. I know I could possibly export the calendar as a csv, then come up with a way of doing a count, or even a pivot chart in excel and maybe import that back into SharePoint, but I was hoping for a more dynamic solution, where the chart would be linked to the calendar, and would update as new events are added. Is this possible?
