Forum Discussion

EAfang's avatar
EAfang
Frequent Visitor
10 years ago
Solved

Line Graph with 10 Minute Intervals on x-axis

Hello Power BI Users Please I started working on a personal IT project that uses Power BI to create dashboards. I want to create a line graph with 10 minutes intervals that shows a plot of KPI like...
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    EAfang

     

    Create another calculated column

    Setup Time2 =
DATE ( YEAR ( 'BI Folder'[Setup Time] ), MONTH ( 'BI Folder'[Setup Time] ), DAY ( 'BI Folder'[Setup Time] ) )
    + TIME ( HOUR ( 'BI Folder'[Setup Time] ), FLOOR ( MINUTE ( 'BI Folder'[Setup Time] ), 10 ), 0 )

     

    And an extra measure

    ASR in last 10 mins = CALCULATE(DIVIDE (SUM ('BI Folder'[Answer Status]), COUNTA('BI Folder'[Session Status])),LASTNONBLANK('BI Folder'[Setup Time2],""))

     

     

    If it answers your question, please accept it as answer. For any question, feel free to let me know.

EAfang's avatar
EAfang
Frequent Visitor
10 years ago

Eric_Zhang

 

Thank you! Thank you!! & Thank you!!!

In fact I'm loving Microsoft even more for a community like this.

 

You sure have answered my primary question and I have accepted your last post as the solution. But please is there a way to view the second to last ASR value (46.86%) on the CARD VISUAL instead of the last [ongoing] ASR (33.44%)?

 

Calculate Lastnonblank

 

 

Thanks

scass's avatar
scass
Icon for Advocate II rankAdvocate II
10 years ago

I'd add a complete interval flag on the database side, filter on that and get the MAX(Interval).

  • EAfang's avatar
    EAfang
    Frequent Visitor
    10 years ago

    scass

    Thanks for sharing other alternative solutions.

     

    scass & Eric_Zhang & ankitpatira

     

    I'll be signing up for Azure Services this week.

    In addition to the above request (on how to view the second-to-last ASR on card visual using the CALCULATE function), I will also like to know if this implementation will work please.

     

    IMPLEMENTATION

    Want to analyze + visualize CDRs from several machines on a local network. So I intend spinning;

    1. A Virtual Machine on Azure running CentOS, which I'll VPN into our local network so I can transfer all CDRs to it.
    2. This virtual machine in turn will continuously send all CDRs to an Azure SQL Database that creates only relevant tables from CDRs.
    3. Power BI only then needs Query the SQL Database to get it's visuals as needed.
    4. Then I can simply get my workmates to sign up for the Power BI service so they could all view dashboards in REALTIME.

    Please is there a more COST EFFECTIVE implementation that you can think of, maybe one that uses other Microsoft services?