cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Samrawit21 Member
Member

Display values in 10 mins interval

 
11 REPLIES 11
themistoklis New Contributor
New Contributor

Re: Display values in 10 mins interval

@Samrawit21

 

This link will help you.

Community Support Team
Community Support Team

Re: Display values in 10 mins interval

Hi @Samrawit21,

 

I'd like to suggest you add a calculate column to convert time value as specific range. Then you can create a time interval table and build relationship between above column and time interval table column.

 

Table sample:

Time interval =
SELECTCOLUMNS (
    GENERATESERIES ( TIME ( 0, 0, 0 ), TIME ( 23, 59, 59 ), TIME ( 0, 15, 0 ) ),
    "Start", [Value],
    "End", [Value] + TIME ( 0, 14, 59 ),
    "Index", (
        HOUR ( [Value] ) * 60
            + MINUTE ( [Value] )
    )
        / 15,
    "Rolling interval", [Value]
)

19.PNG

After these steps, you can use time interval column(rolling interval) and original table amount to create visual graph.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Samrawit21 Member
Member

Re: Display values in 10 mins interval

Hello @v-shex-msft  Sorry for replying late it was a Christmas break
I didn't understand your solution and it is not me who accepted it as a solution 🙂
How can I create a calculated column to convert time value as a specific range? I have created a calculated column, time interval(time2) and made a relationship between rolling interval and time2 column, but it didn't solve my problem(it still shows me 6 body values in 10 mins) and when I try to use rolling interval on a shared axis the other columns from the original table doesn't display value on the visualization(For example, Airflow and body value)
Below is the time interval column I created

 

time2 = DATE(YEAR(CombinedTable[Date]),MONTH(CombinedTable[Date]),DAY(CombinedTable[Date]))+TIME(HOUR(CombinedTable[Date]),FLOOR(MINUTE(CombinedTable[Date]),10),0)

 

Capture.PNG

Highlighted
Community Support Team
Community Support Team

Re: Display values in 10 mins interval

HI @Samrawit21,

 

Can you please share a sample pbix file with some sample data for test?


Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Samrawit21 Member
Member

Re: Display values in 10 mins interval

Hi @v-shex-msftdon't have the permission to upload .pbix files

Community Support Team
Community Support Team

Re: Display values in 10 mins interval

HI @Samrawit21,

 

You can upload sample file to onedrive or google drive and paste share link here..

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Samrawit21 Member
Member

Re: Display values in 10 mins interval

Hi @v-shex-msft

To revise my question
On the visualization, The body column shouldn't show values more than 3, because we only have 3 body sensors in the room. Whenever there is someone in the room(near to the sensor) the body sensor can send values more than once in 10 mins interval , So whenever the body sensor sends a value(1) more than once in 10 mins interval I want to take only 1 value for each body sensor ABC, DEF, GHI, So I can see how many people were in the room in 10 mins interval.

I hope it's clear.

 

https://drive.google.com/open?id=1bjP99zYKt0H2HezA5r4b6MzkXrsw8NOs

Samrawit21 Member
Member

Re: Display values in 10 mins interval

@v-shex-msftdoes the file open for you?

Community Support Team
Community Support Team

Re: Display values in 10 mins interval

Hi @Samrawit21,

 

You can try to use following measure which use firstnonblank function to filter these same value based on current type and time interval:

First BodyValue =
CALCULATE (
    FIRSTNONBLANK ( Append1[BodyValue], [BodyValue] ),
    FILTER (
        ALLSELECTED ( Append1 ),
        [Type] = MAX ( Append1[Type] )
            && [TimeInterval] = MAX ( Append1[TimeInterval] )
    )
)

7.png

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 168 members 1,962 guests
Please welcome our newest community members: