Hello, I have a slice for closed requests that has this expression:
IF(LOOKUP(USEREMAIL(), Directory, Email, Office) = "Users",
AND(IN([Status], {"1", "2", "3", "4"}), USEREMAIL()=[AppUser]),
IN([Status], {"1", "2", "3", "4"}))
showing for accounts with Office = "Users" their requests in status 1, 2, 3 or 4 and for all other users the totality of the requests in status 1, 2, 3 or 4. In the related view I have an action to export it to a csv file and all is right.
Then, I have another slice for open requests that has this expression:
AND(NOT(IN([Status], {"1", "2", "3", "4"})), IN([Companies], SELECT(Directory[Company], [Email]=USEREMAIL())))
showing to users who has their company listed in "Companies" and not having status in 1, 2, 3 or 4
This view shows me the correct data... but when I click on the action to export csv file, the file is empty.
Why this happens ? Any idea ?
Have you tried checking the Audit Logs for any errors?
Hello WillowMobileSys,
yes... but nothing is reported in logs.
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |