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
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
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