Performing Mathematical Operations with Dimension Fields in Data Explorer

[carlos_carreno]

"Good afternoon, I require your assistance with a Data Explorer query. I have two fields within the dimensions that I'd like to use for mathematical operations. Could you please help me understand how to perform calculations with data from within these dimensions?"

111996- 111994= 2 example

thanks

[Peter_Youssef]

Hello @carlos_carreno 

Switch to advanced mode and apply the required mathematical calculations.

Regards,

[carlos_carreno]

Thank you for the guidance. However, I'm struggling to capture individual data from the dimension to perform the mathematical operation. Could you please help me extract these two dimensions?

com.dynatrace.extension.sql-oracle.dataguard.seqDifference:splitBy("destination.type",destination,"database.mode","recovery.mode","gap.status","instance.name","database.type",device,"dt.entity.sql:com_dynatrace_extension_sql-oracle_instance","primary.current.seq","primary.archived.seq","standby.applied.seq"):names:sort(dimension("primary.current.seq",descending)):limit(1)

"primary.current.seq" - "standby.applied.seq"

How would the syntax be, since I've searched in the documentation and haven't found the way?

Thanks

[Julius_Loman]

Arithmetic expressions in advanced mode cannot be applied to dimension values, they can be applied only to metric values. Unfortunately.

Just a reminder - dimensions should not have high cardinality and if you send volatile values for dimension, you may run into cardinality limit very soon.

[PacoPorro]

Can I suggest you create different metrics for the current sequence and the applied seq? 
This will let you do the maths.