Forum Discussion
Percentage calculation
Hi, I have half hourly intervalwise raw data available on which when I use pivot in excel and get #DIV error, I replace those with '0' which make my pivot look presentable. However, when I use th...
Hi,
I am actually new to this environment. Can you explain me what 1dv is?
Hi,
I am not able to connect to Microsoft OneDrive as of now. However, I am pasting my data below. Let me know if it helps..
Date Time Total Calls Offered Total Calls Answered Calls Answered After 20 Sec Calls Answered within 20 Sec Abandoned Calls Abandoned <10 Sec SpeedOfAnswer Talk_time ACW_Time Hold_time Handled calls LOB 01-Feb-17 0:00 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 0:30 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 1:00 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 1:30 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 2:00 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 2:30 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 3:00 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 3:30 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 4:00 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 4:30 1 1 0 1 0 0 3 199 3 0 1 Prepaid 12345 Gold 01-Feb-17 5:00 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 5:30 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 6:00 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 6:30 1 1 0 1 0 0 4 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 7:00 0 0 0 0 0 0 0 324 7 0 1 Prepaid 12345 Gold 01-Feb-17 7:30 2 2 1 1 0 0 37 260 10 0 2 Prepaid 12345 Gold 01-Feb-17 8:00 2 2 0 2 0 0 8 153 7 0 1 Prepaid 12345 Gold 01-Feb-17 8:30 1 1 0 1 0 0 0 705 10 41 2 Prepaid 12345 Gold 01-Feb-17 9:00 1 1 0 1 0 0 4 87 7 0 1 Prepaid 12345 Gold 01-Feb-17 9:30 5 5 1 4 0 0 47 580 23 33 5 Prepaid 12345 Gold 01-Feb-17 10:00 1 1 0 1 0 0 4 51 3 0 1 Prepaid 12345 Gold 01-Feb-17 10:30 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 11:00 1 1 0 1 0 0 21 131 7 0 1 Prepaid 12345 Gold 01-Feb-17 11:30 10 10 0 10 0 0 30 769 54 0 10 Prepaid 12345 Gold 01-Feb-17 12:00 8 8 0 8 0 0 27 183 40 0 8 Prepaid 12345 Gold 01-Feb-17 12:30 1 1 0 1 0 0 4 85 7 0 1 Prepaid 12345 Gold 01-Feb-17 13:00 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 13:30 3 3 0 3 0 0 4 517 17 46 3 Prepaid 12345 Gold 01-Feb-17 14:00 3 3 0 3 0 0 8 547 17 0 3 Prepaid 12345 Gold 01-Feb-17 14:30 2 2 0 2 0 0 8 300 10 0 2 Prepaid 12345 Gold 01-Feb-17 15:00 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 15:30 1 1 0 1 0 0 3 246 3 62 1 Prepaid 12345 Gold 01-Feb-17 16:00 1 1 0 1 0 0 1 100 3 0 1 Prepaid 12345 Gold 01-Feb-17 16:30 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 17:00 3 2 0 2 1 0 6 280 3 0 1 Prepaid 12345 Gold 01-Feb-17 17:30 0 0 0 0 0 0 0 107 3 0 1 Prepaid 12345 Gold 01-Feb-17 18:00 2 2 0 2 0 0 8 258 6 0 2 Prepaid 12345 Gold 01-Feb-17 18:30 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 19:00 7 7 1 6 0 0 44 1282 15 0 5 Prepaid 12345 Gold 01-Feb-17 19:30 5 5 0 5 0 0 11 1262 21 0 7 Prepaid 12345 Gold 01-Feb-17 20:00 1 1 0 1 0 0 4 78 3 0 1 Prepaid 12345 Gold 01-Feb-17 20:30 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 21:00 3 3 1 2 0 0 38 1003 9 0 3 Prepaid 12345 Gold 01-Feb-17 21:30 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 22:00 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 22:30 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 23:00 0 0 0 0 0 0 0 0 0 0 0 Prepaid 12345 Gold 01-Feb-17 23:30 2 1 1 0 1 0 76 60 3 0 1 Prepaid 12345 Gold - Hi jeevan_mehra,
Before you can use your data you have to prepare it and put it in a datamodel with calendar table.
I would before starting to calculate, add an index column as a primary key and afterwards unpivot all columns except index, date, time and the one with prepaid gold in.
Afterwards you can create measures using this data. If you don't know how to start, I would suggest you take the edx powerbi course which is great introduction to the tool and it does a great job explaining the tool
