I wanted to inquire if there is any new application in the recent release that could enhance data viz or any other application that I should consider using to make any reports more meaningful for the client. Your insights on this matter would be greatly appreciated.
Hey, I have total sales (in the millions), avg. selling price (max $20/unit) , and then a % metric. I want to have them all together in a time series chart to show trends. I can't figure this out for the life of me because I can't get them all appropriately graphed without taking one off the graph completely to see. Make…
Hi, Is there a way to have a route map create a triangle? The idea is to have 3 variables with different locations and to mix and match them and for them to create a triangle, however, I only see where you can put long and lat for 2 locations and not three. Is there a way to have three locations?
I have a google sheet of goals that has a calculated cell that sums all in the column. Is there a way to access this number and use it? I have another dataset that gives me actual sales, and I want to use a filled gauge that shows actual to Goal. thanks, Brian
Hi, I am trying to create a % by taking a filtered value in Column A and dividing it by other, multiple filters in Column A. I am able to create the numerator, however, when creating the denominator, I can't get it to register more than one filter. I've tried 'AND' and 'OR' statements, but no avail. See below: SUM(CASE…
I have a request on how to create a time Monthly Stacked bar chart of Total Retail Volume with Total Member Volume and represent it by hour for any given month. I am have issues with grouping the times between 7am to 8pm; I just get every data point for the given month I don't know how to group together. Here is a picture…
Hi I want to add another variable to the above equation but can't get it to work. In my Excel days, I would use an IF statement. Here is my equation: when 'primary class' = 'supermarkets and grocery stores' THEN sum(case when `Split answer` = 'Female' then `Value` else 0 end) / sum(`Value`) Thanks Ben
Hi All I have a dataset (a sample is attached) where the 2 series I want to track are in the same column, identified by the Split Answer (i.e. male or female). I want to calculate the % split answer value by dividing the value by the sum of all values where the Split Detail is held constant (i.e. what is the % of female…
I am wanting to recreate the X-Axis here only showing days - then show changes MoM using lines. Ultimately, I want to create a filter that allows users to pick how many days they would like to go back and allow that to be compared. Any suggestions?
Hello everyone, Is there a way to work out the formatting of dates that are originally dates with timestamps to only dates without having to change anything inside the ETL? Screenshot below: Basically, I want to remove the timestamp part and just keep the date. Is there a way to work out this formatting on the dashboard?…
It looks like you're new here. Sign in or register to get started.