Forum Discussion
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 in each sale 2 sellers participate and I at the end want to show me in a graph the number of times that the seller has participated, and I can not
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 2I 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.
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
9 Replies
can you post sample data and a depiction of the expected outcome?
That's my data and I want the graphs to represent the number of times we saw a client, but also respecting client 1 and client 2
Please post data. We can't work on an image. Also show a depiction of the expected outcome
ID GUY DAY DATE HOUR CLIENT 1 CLIENT 2 COUNTRY LEVEL SELLER 1 SALE FRIDAY 27/08/2021 22:15 ARMASA EXTRUAL SPAIN 1 Series FRANCISCO 2 SALE FRIDAY 27/08/2021 19:30 EXTRUAL STEELS C SPAIN 2nd ANTONIO 3 SALE FRIDAY 27/08/2021 21:30 METAL ETD SPAIN 1 Series ANTONIO 4 SALE SATURDAY 28/08/2021 17:30 UNION ARMASA SPAIN 3 Series AITOR 5 SALE SATURDAY 28/08/2021 19:30 IRONS BARCELONA ALGECIRAS SPAIN 2nd OSCAR 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
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?
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 2I 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.
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
