Sub-query in Quick sight

Q&A
,
1

Hi,

I have transactional data set.
Each transaction is linked to employee.
I would like to present a report with daily average number of transactions per employee.
How can it be achieved in quicksight?

I need to have average function over daily count function.

Thanks

2

Hi @Annab

QuickSight supports simple avg() and level aware avgOver() functions .

Please check our DemoCentral website for more detailed examples of QuickSight functions and sample dashboards.

Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”.

This will help the community to find guidance and answers to similar question. Thank you!

3

Hi, I am marking @apjvinod reply as a solution. Please let us know if you need further assistance.

4

Hi @Asem,

I have used the avgOver and was able to calculate the daily average per employee.
avgOver(count{trx_id}),[{employye_name}])

However, in order to present it I need to add to the table the employee_name and trx_date.
Once I remove the trx_date from the view, the average is calculated per day and presents exactly same values as the count per day.

So, I tried to use the following calculation:
avgOver(count{trx_id}),[{employye_name},{trx_dae}])
and when using in the table only employee name and daily average measure got the following error:
VISUAL_CALC_REFERENCE_MISSING

How can I have a table presenting the employee_name and average_daily_number_of_transactions?

Thanks,
Anna

5

Hi @Annab,
Can you try using the following calculation:
avg(count({trx_id},[{employye_name},{trx_id}, {trx_dae}]))

Let us know if this helps.
Thanks,
Asem.

6

Hi @Asem

I did the following:
avg(count({trx_id},[{employye_name},{trx_dae}]))
and it worked.

Thank you!