Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

help on chart web traffic

hi all,

I have a website and it running on a campaign for 1 month..

Is there a way to show during this month, what time is the highest traffic?
Attached is the sample file, is there a better way to show it?

Any advice is greatful. Thank in advance.

Need Help
  • v-joesh-msft's avatar
    v-joesh-msft
    6 years ago

    Hi Anonymous ,

    Try the following measure:

    highest traffic =
CALCULATE (
    MAX ( Sheet1[Hour] ),
    TOPN (
        1,
        ALLSELECTED ( Sheet1[Hour] ),
        CALCULATE ( SUM ( Sheet1[View] ) ), DESC
    )
)

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

  • v-joesh-msft's avatar
    v-joesh-msft
    6 years ago

    Hi Anonymous ,

    Here are two ways to see if it meets your requirements:
    1. Create the following new table and apply for Multi-row card:

    Table = TOPN (
        3,
        ALLSELECTED ( Sheet1[Hour] ),
        CALCULATE ( SUM ( Sheet1[View] ) ), DESC
    )


    2. Create the following measures and apply for Multi-row card after filtering:

    Rank = RANKX(ALL(Sheet1[Hour]),CALCULATE(SUM(Sheet1[View])),,,Dense)

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

7 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    Anonymous try this measure

     

    Max Hour = 
CALCULATE ( 
    MAX ( Sheet1[Hour] ),
    TOPN ( 1, ALLSELECTED ( Sheet1[Hour], Sheet1[Date] ), CALCULATE ( SUM ( Sheet1[View] ) ), DESC ) 
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      i tried this method, but not enough memory for my data...any other ways?

      • v-joesh-msft's avatar
        v-joesh-msft
        Icon for Solution Sage rankSolution Sage
        6 years ago

        Hi Anonymous ,

        Try the following measure:

        highest traffic =
CALCULATE (
    MAX ( Sheet1[Hour] ),
    TOPN (
        1,
        ALLSELECTED ( Sheet1[Hour] ),
        CALCULATE ( SUM ( Sheet1[View] ) ), DESC
    )
)

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

  • v-joesh-msft's avatar
    v-joesh-msft
    Icon for Solution Sage rankSolution Sage
    6 years ago

    Hi Anonymous ,

    You can try the following method:
    1. Create the following measure Rank:

    Rank = RANKX(ALL(Sheet1[Hour]),CALCULATE(SUM(Sheet1[View])),,,Dense)

    2. Apply Rank to the filter and set the value of Rank equal to 1:

    Here is a demo, please try it:

    https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EWQduaFvIhZBi7XG_mRR6skBe289p2kQ12t85e6pv-c-Fw?e=WckJRm

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      hihi...is there a way to show as a card visual or chart instead of table?

      I tried but doesnt seem working.

      Thanks so much