I have the following table within my output Cust_No Start_Date End_Date Comp_Val Monthly_Val 123 2023-01-01 2023-06-30 1100 55.95 123 2023-07-01 2024-02-05 1100 22.90 As you can see, the months between start_date and end_date for this example, is 13+ months. What I would like to see is a row for each Year_Month between…
Is it possible to have a Quick Filter allowing user to select which type of measure is included as a value on a chart? For example I have Spend and Savings; if the user selects Spend the chart would pull in Spend and if Savings is selected the chart would pull in Savings only as the value.
Hi, Is there a way to have a Chart display blank data until filtered. For example I have two charts one with products x,y,z and then the other being a blank chart. When I click on product X, I want the blank chart to display every customer. When no product is selected I want the chart to be blank. Hopefully that makes…
Currently I am having issues getting the pfilter query param with the embed working in an iframe. I have followed many of the examples out there and have replaced every special character in the value with their ascii counter parts but nothing has seemed to work Here is an example of what I have been trying:…
one of the column in my dataset is $$$. However, it is in the Dimensions and will not calculate.
I'd like to know how to take the percentage of a metric without showing other portions - for instance: I have footballs, basketballs, baseballs and lacross balls. If I sold 35 footballs, 25 basketballs, 20 baseballs and 20 lacrosse balls in Q1, in Q2 I sold x footballs, x basketballs etc. I want to see the percentage of…
Hi Folks, Question: How do I identify blank values in a pivot chart? I want to filter where all values are blank against any column in a pivot chart but no option. I can't do it in the ETL either because it needs to be dynamic based on a date selection. (dates are the columns) Context I have the fields 'People', 'Dates',…
Not sure why I'm getting the below bar charts to show the 2 stacked values in a different order for each. Top graph shows Call + Slides (blue) on bottom of bar, Bottom graph shows Call + Slides (green) on the top of bar. I've not been able to find anything posted and have not seen any setting in the graph settings to…
I have a dataset where each dow represents a daily transaction 'date' for the 'productSKU', 'size', 'sales channe'l and also contains other columna where it sums the 'sales', 'stock on hand', 'units sold', etc I am trying to create a calculated field for 'sales last year' as a column for the 'sales' from a year ago for the…
I have a graph setup giving me daily data. (e.g. sales). I've used as part of the graph "Multi-Period Projection" and set it for 5 days out. What I want to know is how accurate this is to the actual. Today is 1/31/2023 and sales was $1M, and the prejection for 2/3/2024 is $1.3M, I want to know how close the projection was…
It looks like you're new here. Sign in or register to get started.