Dashboards & Analytics Discussions

Need to Calculate Difference of Date/Times of Same Column

I have data in the below format:ResourceNameTxnDateTxnTypeNameContainerNameQtySpecNameProductNameSR10-481/23/23 3:41 PMMoveInAG6826626600F83_SU_SP00346-20016ASR10-481/23/23 3:42 PMMoveStdAG6826626600F83_SU_SP00346-20016ASR10-481/23/23 3:42 PMMoveInAG...

the undiscovered country

I think I found a bug in the toChar() function but want to make sure here first.When using the format "HH:mm", toChar() does not emit 24 hour time format. Instead it emits "hh:mm" format. Also, if I try to give it "hh:mm a" as a format string, it com...

Unable to create Incorta Analyzer

Hi Gurus,I am encountering below issue while attempting to create a derived table (Incorta Analyzer)INC_04050134: Failed to materialize derived table. Incorta Analyzer/SQL tables over source tables having session variables is not a supported feature....

Calling a Stored Procedure/Function in Incorta

Hi All,I just to understand, is there any method or options to call a stored procedure/function in Incorta?Regards,Mritunjay Sinha

Calculation based on Custom calendar and non joined tables

Hi Gurus,I need some pointer to complete analysis for below requirement .Requirement:We need to create a monthly trending report which shows Last month's data, adding upto 12 months. i.e.Just say for Year 2023, the report should show ;In the month of...