Forum Discussion
Reshape data
Hi Anonymous,
You can take a look at below sample:
1. Source table.
RecordsTime list
2. Calculated column formula to calculate the count.
Count = COUNTAX(FILTER(ALL('SampleFile'),[StartTime]<=[Hour]&&[EndTime]>=[Hour]),[User])+0Resut table
Regards,
Xiaoxin Sheng
Thank you danrmcallister for your reply. Its pretty close but what I find with Calculated Column is that I lost some filters context. For example my Table1 has relationship with other tables as well. In addition, I found that if I apply slicers the Online Users calculated column do not change....
For example if I want to slice by User A, the online number doesnt change - why is that?
Hope you can advice.
Resolver II
Anonymous hmmm, it works for me. I added another table to my data that classifies that user A is an Accountant and User B is a Developer. I added that as a pie chart to the data and the slicer works fine so long as i set the cross filter direction in the relationship to Both. Check out the screenshots below and let me know what you think.
Does that help?
Im not sure why it doesnt work for me :(
Basically I got kida snow flake type of schema...
- LogTable (table1)
- Time (table2)
- Structure (link with logtable by Userid)
- Location (link with Structure by Structure id)
So I need to be able to slice it by structure and location. I guess thats where i went wrong. But even if I slice it y User as per your example it didnt seem to return the right number of rows :(
Hi Anonymous,
You can take a look at below sample:
1. Source table.
RecordsTime list
2. Calculated column formula to calculate the count.
Count = COUNTAX(FILTER(ALL('SampleFile'),[StartTime]<=[Hour]&&[EndTime]>=[Hour]),[User])+0Resut table
Regards,
Xiaoxin Sheng
- danrmcallister
Anonymous
If you could supply some screenshots of your tables that would be helpful to figure out what's happening. It could be as simple as a data formatting issue! Hard to say.
Dan