Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a table below:
I am trying to get the average of "someNumber" (which is number of seconds) per date and then convert that number into miutes and seconds.
So, I am drawing the graph below:
As you can see, I used the average filter and it calculated the average of "someNumber" per date. For instance, the average on 1st is 13. Now, how do I convert 13 into minutes and seconds so that I can display it as a tooltip?
Solved! Go to Solution.
Hi @sieed,
I try to reproduce your scenario and get expected result.
In report interface, the hierarchy of date is to day level rather than hour, minute, and second. You'd better create measure to calculate the average of number on minute and second.
Minute = CALCULATE(SUM(Test[SomeNumber]),ALLEXCEPT(Test,Test[date].[Day]))/DATEDIFF(CALCULATE(MIN(Test[date]),ALLEXCEPT(Test,Test[date].[Day])),CALCULATE(MAX(Test[date]),ALLEXCEPT(Test,Test[date].[Day])),MINUTE)
Second = CALCULATE(SUM(Test[SomeNumber]),ALLEXCEPT(Test,Test[date].[Day]))/DATEDIFF(CALCULATE(MIN(Test[date]),ALLEXCEPT(Test,Test[date].[Day])),CALCULATE(MAX(Test[date]),ALLEXCEPT(Test,Test[date].[Day])),SECOND)
Then create a line chart to display the result.
The result is little, so you see the two line is closest to coinciding. Actually, they are different.
Best Regards,
Angelia
Hi @sieed,
I try to reproduce your scenario and get expected result.
In report interface, the hierarchy of date is to day level rather than hour, minute, and second. You'd better create measure to calculate the average of number on minute and second.
Minute = CALCULATE(SUM(Test[SomeNumber]),ALLEXCEPT(Test,Test[date].[Day]))/DATEDIFF(CALCULATE(MIN(Test[date]),ALLEXCEPT(Test,Test[date].[Day])),CALCULATE(MAX(Test[date]),ALLEXCEPT(Test,Test[date].[Day])),MINUTE)
Second = CALCULATE(SUM(Test[SomeNumber]),ALLEXCEPT(Test,Test[date].[Day]))/DATEDIFF(CALCULATE(MIN(Test[date]),ALLEXCEPT(Test,Test[date].[Day])),CALCULATE(MAX(Test[date]),ALLEXCEPT(Test,Test[date].[Day])),SECOND)
Then create a line chart to display the result.
The result is little, so you see the two line is closest to coinciding. Actually, they are different.
Best Regards,
Angelia
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |