• Replies 10 replies
  • Subscribers 700 subscribers
  • Views 93 views
  • Users 0 members are here
Options
Related

Date's in one column. / Changes in days

Alexander Grieves
$organization

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 .

Parents
  • $organization

    You will need to put it in the Values section. You'll need to combine either MIN or MAX with DDIFF functions.




  • $organization in reply to Neil Cole

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

Reply
  • $organization in reply to Neil Cole

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

Children
No Data