Hello, I want to create a column in an NDT that concatenates two fields. view: ndt_sessions { derived_table: { explore_source: sessions { column: website_name {} column: partition_date {} column: id {} } }}I want to derive the column id{} from two fi...

I have a query result with a Pivot in it. The data looks as shown below: Pivoted DataI have Type_A to Type_F as my pivoted columns, I want to add up the columns Type_C and Type_D using one table calculation and add up the rest of the columns of the p...

Hello Folks, I have the following requirement. I have a query result that is in this format: Month Number Landing Page URL Transactions Page Type Revenue Conversion Rate 1 / 100 ? $200 5.4% 1 /cart 500 ? $1000 11.5% 1 /blog/how-to-jump 4 ? $50 0.3% 1...

Hello, I have a query where I am trying to visualize Site Visits by Page Type. The X - Axis is Page Type, the Y Axis is Site Traffic. I have pivot on it to show the Site Traffic by Page Type for this year and last three years. The visualization right...