Question about calculated field

Question & Answer
,
1

–Read and delete–
If your question is about data calculation/presentation, we encourage you to create a sample dashboard in Arena and include it with your question. This makes it easier for other users to try solving your problem and highly improves your chances of getting a solution quickly.
Read more about Arena here: QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community
(Copy / right click link in preview on a PC --or-- highlight / control / click link on a Mac and open in new tab.)
–

So I have been involved in migrating dashboards from tableau to quicksight. So I have got stuck with an calculated field which I m not able to convert in quicksight?
Calculated field formula in tableau - {fixed DATETRUNC(‘hour’,[createdate]): COUNTD([userid])}

Could you please help with an formula for quicksight?

2

@samytar97

You can use QuickSight´s functions like “distinctCountOver” and “extract” to replicate the expression above and reach the goal.

Something like that: distinctCountOver( userid, [ extract ( ‘HH’, createDate ) ] , PRE_AGG )

Regards, @jose_burrull

1 Like