Forum Discussion

JMHenriques's avatar
JMHenriques
Frequent Visitor
2 years ago
Solved

get working days since datetime until NOW with decimals

Hi all,   I have a Calendar Table with IsWeekend and a table with a "created_at" column in Datetime format.   I need to count the days and hours passed since the "created_at" until the refresh da...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi JMHenriques ,

     

    Thanks to CKN  for the idea.

    JMHenriques Your Tickets table are being filtered because you're using a slicer about “created_at”. When you select a value in the slicer, Tickets table is filtered. If you want to disable this filtering, you can use the Edit Interaction feature.

     

     

    Best regards,

    Mengmeng Li

CKN's avatar
CKN
Frequent Visitor
2 years ago

if it's for all weekends (not treating any days such as holidays differently) can you use the figure you already have for hours, divide by 24 for days then by 7 for weeks to get the number of weekends. Round it down and multiply by 48 for hours.