Dashboards & Analytics Discussions

Parse Timestamp

Hi,could you please let me know how to convert string to date of "4/1/2022 3:48:00 PM".

Resolved! Filter by Date on three different date column

Hey There!I have filtering requirement, to apply the filter on three date columns, such as received, Approved and Rejected date:example: When user select between particular date, filter should apply on three date column as stated above, if either of ...

Resolved! How do I default the max date of a table as a default value in a Date prompt in a dashboard?

The usecase here is how to calculate the max date from a table column and then default that to a date prompt in a dashboard.

Join two tables - only no matched rows

Hi Everyone,I would need help, I have both dataset below:1. Company item - contains all items assigned to company and branch2. Stock - contains stock value assigned to company, branch and items (there are only items having stock value > 0)What I need...

Condition when sending schema notifications (sFTP)

Hi,We send csv/excel sheets to a sFTP server for different use cases. Is there a way not to send an "empty" excel/csv file, the same way we have with data condition in data notifications? Or is there a way to send sFTP data via Data Notifications?Onp...