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 t...
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.

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    It work perfectly.

    by the way, For the topN, if i wanted the top 3, possible?

    I tried changing the number but it doesn't work.

    Thank you

    • v-joesh-msft's avatar
      v-joesh-msft
      Icon for Solution Sage rankSolution Sage
      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.