Hello,
Forgive me if this a really obvious, but thought it was worth an ask.
When looking at the Production Season Start Date (days in date) and the Production Season End Date (days in date) I can only seem to add them In two columns within a Pivot table. I would ideally like to have it in one collumn represented as Start Date - End date (01/01/2024-06/01/2024) but I can't seem to see an option to do so?
Secondly when looking at the DDiff function for looking at sales over the past 2 days & past 7 days, it seems to just give me the total when using [Total Ticket Sales] as the data, and tips on this would also be appreciated
Thanks
Alex .
You will need to put it in the Values section. You'll need to combine either MIN or MAX with DDIFF functions.
Sorry, it i wasn't clear, this was to have the date in one column as a range opposed to a sum value
For the last 7 days only, you could either add an Order Date filter on the widget or dashboard. Otherwise, you could add it on the formula (values) level. This is called a "filtered value." It is just wrapping everything with parenthesis and adding filter(s) after the comma.
Syntax: ([Aggregation] , [Filter1], [Filter2], FilterN])To only include the last 7 days, add Order Date as the filter, right click, chose filter, Time Frame = Last 7 Days.
If you don't want to include today's date in the 7 days computation, click on Advanced, change the offset to 1.
Notice that when I click Test, it only shows 6 matches. This is because we didn't have any sales between midnight and 1:00 am on today's date when the Analytics data updated.
When I set the offset to 1 and click Test, it shows the actual last 7 dates.
I also immediately Rename the item in the formula so I can quickly see what it is filtered to.Things like this allow you to show the total tickets as well as the Last 7 days of sales.
One thing to check is if there is a difference between the count of sli id versus Ticket Count. I've found (with our set-up) that they occasionally do not match. I now only use the COUNT([SLI ID]) (which is the same thing as [# of unique SLI ID]) instead of the value from Ticket count -> sum([Ticket Count]) or [Total Ticket Count].
Thanks that worked! Thanks so much Neil Cole
I just tried to replicate in the finance cube also, looking at the ticket purchases amount (i.e. total income) in the last 7 days but testing returned 0, assume there might be a different way to do this, if you have any advise
In the Seats and Tickets Cube, you can access Total Paid Amount.When you add a widget, you can change the data source.
How about Ticket Paid Amount in the Finance Cube?
Yeah, using Finance cube (using this for budget figure) then looking at ticket paid amount in days (similar to above)
From the Help system. This will tell you the difference between the Finance Ticket Paid Amount and Ticket Purchase Amount.
That Cracked it thanks for your help!
Glad to help!