Forum Discussion

steambucky's avatar
steambucky
Helper III
8 years ago
Solved

How do user a SLICER on a count?

The short question is - how would slice a count?

 

My company is trying to view trends in the type and amount of datasets that our customers are downloading.

 

We have becoming interested in customers download one file and never come back. We want to look at all of these all of these single downloads and see if there is a trend.

 

Ideally I would like to have slicer where we can select a range of downloads and see what

 

In this specific example I would like to be able to just view what the people who are downloading 1 data set ( by using a slicer but how ) and then viewing the percentage break down. In reality we would want to be able to have a range of downloads we were downloads we were slicing the data by.

 

 

Note: The supplied example is very small sample example of the amount downloads we have. The actional amount of records is 100000 plus.

 

 Any advice is welcome.

Need Help
  • RA_gov's avatar
    RA_gov
    7 years ago

    How would I add a count as an additional field in a slicer?

    I have a map report with properties in US states.  My current slicer is STATE.

    I want to add the count of properties in each STATE on my slicer for my users.  I need guidance on how to do this.


    Example:

    [check box]   AK  4

    [check box]   AL  7

    [check box]   AZ  2

    [check box]   CA  9

     

    Thanks.

7 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    Hi steambucky

    What should the " a range of downloads" be?

    Look at my test, based on your screenshot, create a calculated column "data" to distinguish the data type 

    data = IF(LEFT([data download],10)="data type",LEFT([data download],10),LEFT([data download],9))

    Then import a customer visual "Hierarchy Slicer" from marketplace.

    Add "data" and "data download" to the slicer

     

    Best Regards

    Maggie

    • steambucky's avatar
      steambucky
      Helper III
      8 years ago

      Hello v-juanli-msft,

       

      Thanks for taking the time to reply.  I read your answer but am unsure how to apply it to my query.  I apologise, I dont think i have supplied enough detail to my intial query. 

       

      What I want to do slice buy the number of downloads, but I think I need to show what I am looking for visually?

       

       

      Image 1 - we have numbers of downloads and the the downloads in percentages. Some data is is more popular than others.

       

      Image 2 - If i select all the one time downloaders i can see want they down load and can start looking for trends. What I am after is a slicer that I can select any download amount and see what that "bracket" of our downloaders. We may be interested just looking at the higgest downloaders and so on.

       

      Because of the amount of downloaders, it just is impossible to select them invidually.

       

      Thoughts?

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        8 years ago

        Hi steambucky

        What I am after is a slicer that I can select any download amount and see what that "bracket" of our downloaders. We may be interested just looking at the highest downloaders and so on.

        Do you mean add the “count of email address” column to a slicer for selecting any download amount,

        Here “count of email address” is a calculated column instead of a measure.

         and what do you mean by “look at the highest downloaders”?

         

        Best Regards

        Maggie