Dashboards & Analytics Discussions

Sorting within groups

I have a fairly complex insight w/ the basic structure:Top Parent -> Parent -> leaf --> bunch of summary measures and formula columnsI want Top Parent and Parent sorted alpha, so check! But I want leaf sorted based on one of my summary...

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