DATA SET: Schedule,Punch & TimeOff - Request Status

Question & Answer
, , ,
1

Hi Team,
do you know if there is the possibility to insert a field of a certain DATA SET in an other DATA SET? I have created a Dashboard for the Vacation Plan, and I have used the “Schedule,Punch & TimeOff (past 2 month)” dataset. But I do not have the possibility to filter on Request Status (pending, approved…). It could be very useful have this type of filter to give the correct Vacation Request %
I cannot use the TimeOff dataset because there isn’t the possibility to calculate workable hrs.

Thanks in advance for the help
Dario

2

Hello @Dario_Meligrana !

It sounds like you are referring to internal dataset for your organization, but this a public community forum. My suggestion would be to connect with your data team and ask them to create the custom table.

If you do have access to your data source, you can use Custom SQL in Quicksight to create a join, and bring in that field from the other dataset.

3

Hi @Dario_Meligrana. Checking in. We have not heard back from you regarding your question. We’d still like to help. If we do not hear back in the next 3 days, we will archive the question.

4

Thanks @duncan! Really helpful

1 Like