MODE Formula in Incorta
I there a quick way to enact a Mode formula in Incorta to show the most common value within a measure array?
I there a quick way to enact a Mode formula in Incorta to show the most common value within a measure array?
We are looking for ways to report on what dashboard/insights were shared via email. We want the time, what insight, and who received it. All I could find in the Incorta metadata was the actions table, it contains if an email subscription was setup or...
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...
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...
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...