Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello helpful people.
I am going to do my best to ask this question in a way that makes sense. I have a pivot table:
The field "Count of Machines" is a field calculated by the pivot table that tells how many HOST_NAMEs match to any given Primary Users. I need that field in my data load so I can create visualizations based on it. Does that make sense? How can I do that?
Thanks.
😸
Try below for count of machines by users
Count(total <PrimaryUser> distinct Hostname)
What visualization exactly do you want to create?
Ultimately I'll need to create several. The first one will be a table that will show User, how many devices, device name(s), logon hours, and most recent logon date(s)
Currently I have all those fields except how many devices, which is what the pivot table shows.
You can count them as you are doing now!
I know I must seem incredibly dense, but currently the pivot table is doing the calculation. I don't know how to translate that to a function or into script.
can you post some sample dataset that best represents your actual data- in excel, and also do a mockup up of the expected output
I am so sorry. I knew this was going to be difficult for me to explain. Thank you for your patience.
What I currently have is this:
What I need to be able to add is this:
I don't know how to get the # of machines value nor whether the device is primary or secondary (that would be based on logged on hours). All I'm asking about in this question is the # of machines, I figured the Primary/Secondary question is another subject and will require another message board post.
Try below for count of machines by users
Count(total <PrimaryUser> distinct Hostname)
This works! Thank you!