Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi PowerBI,
I have been asked to produce some nice visualizations for my end user. Here is some sample data that i have:
As you can see, my data mainly consists of working with times (these have come from stopwatches).
I am quite a beginner and i am unsure how to create or work with these times.
Could anyone suggest how i can get the best out of this data and produce nice visualizations.
Something like averages, totals for each etc?
Thanks!
Solved! Go to Solution.
Hi @AaronRogers3,
As the picture you shared, I think the time are all in text format. Here I made a sample for your reference.
1. Enter the data and change the data type to Duration for the time columns in query editor.
2. Add some measures as below.
ave-se = CALCULATE(SUM(Table3[SETUP_TIME]),ALLSELECTED(Table3))/COUNTROWS(ALLSELECTED(Table3))
aver_sele_set = FORMAT(CALCULATE(SUM(Table3[SETUP_TIME]),ALLSELECTED(Table3))/COUNTROWS(ALLSELECTED(Table3)),"hh:mm:ss")
Total time_num = SUM(Table3[SETUP_TIME])+SUM(Table3[PROCESSING_TIME])+SUM(Table3[RECONCILIATION_TIME])
Total_Time = FORMAT(SUM(Table3[SETUP_TIME])+SUM(Table3[PROCESSING_TIME])+SUM(Table3[RECONCILIATION_TIME]),"hh:mm:ss")
3. Then we can get a report like below.
For more details, please check the pbix as attached.
https://www.dropbox.com/s/bzyc11bqjiuktnb/Power%20BI%20Time%20Calculations2.pbix?dl=0
Regards,
Frank
Hi @AaronRogers3,
As the picture you shared, I think the time are all in text format. Here I made a sample for your reference.
1. Enter the data and change the data type to Duration for the time columns in query editor.
2. Add some measures as below.
ave-se = CALCULATE(SUM(Table3[SETUP_TIME]),ALLSELECTED(Table3))/COUNTROWS(ALLSELECTED(Table3))
aver_sele_set = FORMAT(CALCULATE(SUM(Table3[SETUP_TIME]),ALLSELECTED(Table3))/COUNTROWS(ALLSELECTED(Table3)),"hh:mm:ss")
Total time_num = SUM(Table3[SETUP_TIME])+SUM(Table3[PROCESSING_TIME])+SUM(Table3[RECONCILIATION_TIME])
Total_Time = FORMAT(SUM(Table3[SETUP_TIME])+SUM(Table3[PROCESSING_TIME])+SUM(Table3[RECONCILIATION_TIME]),"hh:mm:ss")
3. Then we can get a report like below.
For more details, please check the pbix as attached.
https://www.dropbox.com/s/bzyc11bqjiuktnb/Power%20BI%20Time%20Calculations2.pbix?dl=0
Regards,
Frank
Frank,
Thanks! I have made calculated columns that have the average times for each of my stages.
I was wondering, is it impossible to make these new columns that i have created reactive?
For example, if i click the NOACK option for machine name then they change to the correct data?
Thanks
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |