I have attached a picture of the data to get a better understanding of it. What I am trying to do is to show the ratio between the count of values with BOOKG_REQ_STS of 200 and 100 on a minute basis, using a line chart. And also display that data in a table. Thanks in advance for the help! ... View more

Following is the data I have: Time (DD/MM/YYYY 00:00:00) Delay_class (String value, example "B. > 15 MIN" or "A. < 15MIN") NumberOfOccurances (integer, numeric values of traffic count, for example, "314" or "96606") Others (Fields that are not important in this case)   What I am trying to do is to show a ratio of the two delay classes with corresponding time limitations (like the ones seen in the example) based on the number of occurrences. So, for example, on the 4th of June all of the combined NumberOfOccurances for the delay class of "B. > 15 MIN" are 50000, while all of the combined (summed) NumberOfOccurances on the same day for a corresponding delay class "A. < 15MIN" are 1000000, so I'd like to see the ratio of 0,05 shown in a Pivot table of visualization of some sort. How do I achieve that?  ... View more