Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Two-column ratio

If I have two columns with names of workers and I want it to show me the number of times that the client has intervened regardless of the posicon of the column as I have to do? The example is that ...
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Syndicate_Admin 

    a bar graph can put on the axis the two columns of clients together and when I filter in the table and the count appears to me all the times it was visited regardless of whether it was client 1 or client 2

    I think this is a question of hierarchy, if you put client1&client2 into slicer, then you will see 2 levels in slicer hierarchy,

    Similarly, in bar chart visual, the client1 is the first level, so when you filter in the table, the count will always display the level1 first, then level2 after you select "Go to the next level...", these 2 columns client1&client2 cannot appear in the same dimension at the same time. If they are the same dimension, you need to merge them into one column by using the function Unpivot .

     

    If you need more help, please @ me.

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    4 years ago

    Thank you very much, thanks to unpivot I have been able to solve the problem, also changing a relationship so that you can search in another table

PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

Please post  data. We can't work on an image. Also show a depiction of the expected outcome 

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
IDGUYDAYDATEHOURCLIENT 1CLIENT 2COUNTRYLEVELSELLER
1SALEFRIDAY27/08/202122:15ARMASAEXTRUALSPAIN1 SeriesFRANCISCO
2SALEFRIDAY27/08/202119:30EXTRUALSTEELS CSPAIN2ndANTONIO
3SALEFRIDAY27/08/202121:30METAL ETDSPAIN1 Series ANTONIO
4SALESATURDAY28/08/202117:30UNION ARMASASPAIN3 SeriesAITOR
5SALESATURDAY28/08/202119:30IRONS BARCELONA ALGECIRASSPAIN2ndOSCAR

GLJ_0-1631370005197.png

For example, a bar graph can put on the axis the two columns of clients together and when I filter in the table and the count appears to me all the times it was visited regardless of whether it was client 1 or client 2

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    4 years ago

    Sorry I can't actually see the image clearly. It would be best if you created an example of what you need in a graph in Excel. I'm not sure what you are trying to achieve.

    What goes in the axis? What do you mean when you say you filter in the table? ...What is the calculation you need?

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      4 years ago

      On the axis at this time it only puts client 1, because although it allows porner both columns on the axis always shows the first one that is set, and what I would like is that client 1 and client 2 were unified to be able to look for results of the and show them the axis as a single column or action so that I returned the result of the total number of times that a client is seen

      • Syndicate_Admin's avatar
        Syndicate_Admin
        Administrator
        4 years ago

        I still don't understand what you want to calculate. Please create a simple example in Excel and put it here.