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