Hello,I'm currently working on an Aggregate Insight where I need to compute the minimum Start Date per Tag_ID as part of the dimension section, not the measure. I’m exploring alternatives to a level-based formula such as:min(start_date,groupBy(tag_id...
Hi,I have connected Incorta with Azure databricks using custom sql connector and fetched the data from databricks successfully, But I am not able to see the data lineage for data source (databricks/custom sql connector) when I am checking lineage fro...
Hello Gurus,I am working on the following scenario involving four tables:Table ACol1 Col2 aarefbbref Table BCol1 Col2 axby Join: Table A.Col1 = Table B.Col1Table CCol1 Col2 x100 Table DCol1 Col2 y200 Join:Table C.Col1 = Table B.Col2Table D.Col1 = Tab...
Hello Gurus,I am working on building a logic to filter records based on the Year (e.g., 2025) and Quarter (e.g., Q2) values passed as prompts.I’ve created these prompts as Presentation Variables and am trying to retrieve the corresponding Quarter End...
I am trying to create a pivot table that looks at 2 different sizes of our products and displays the top 10 in each category by the total sales. I was able to sort the sales dollars, but I am not sure how to limit the display. I did use the gear and ...
