Dashboards & Analytics Discussions

Resolved! Issue with Aggregation Logic Using Conditional Joins Across Multiple Tables

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...

Resolved! Issue with Retrieving Quarter End Date Based on Prompts

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...

Displaying the top 10 customers in a pivot table by groups

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 ...

Resolved! Top 10 customers

Does anyone know the best way to populate the top 10 customers?

PySpark Regressions using pyspark.ml Library

I am developing a pipeline for some regression modeling I am experimenting with and I've got a working script and output that I am reasonably happy with. However I am unable to write new scripts using the ml library. I'm not even able to copy and pas...