Dashboards & Analytics Discussions
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! Control column width

I have an insight: aggregate table, transposed with the left-most column in the transposed list having measure names ( think finance statements ).   The leftmost column is also hugely over-wide which makes the insight quite non-ideal for mobile viewi...

RADSr by Captain
  • 1614 Views
  • 3 replies
  • 0 kudos

Resolved! View SQL for an insight limitations

I have an aggregate table insight, it has measures, I'd like to view the SQL representation of the Incorta query but instead of that I view the message ( screen cap below ) helpfully telling me I must be using a listing or aggregate table and have at...

RADSr_0-1655231179696.png
RADSr by Captain
  • 880 Views
  • 1 replies
  • 0 kudos

Resolved! Incorta formula

 Hi Team - Wondering whether below oracle Sql can be achieved using Incorta formula?segment1 is the inputformula_required is the output.select segment1, substr(segment1,1,(length(segment1)-instr(reverse(segment1),'-'))) AS formula_required from dual;...