- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Showing data based upon last sync date
Hi all,
Bit of a novice question I'm afraid.
I'm connected to a data warehouse that I use to show sales of products through selling channel, location, device etc.
My current report lists the location, device number, date, gross receipts and number of issues in a table. Most devices retail every day. Where a device does not retail, that usually indicates that it is faulty.
Is it possible to create a table that shows devices that have not retailed, or a table that shows a breakdown of devices and the last date that the data warehouse holds and sales data for each device?
I'm hoping that in doing so I'll quickly be able to identify potential device failures and get these more proactively fixed.
Thanks
Rob
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I suggest using a regular table visual and using the device, sum of sales, and the latest sales date (you'll need to make sure the dates are actually of type date and not text) in the columns. You can sort the table by ascending latest sales date to find items which have no sales in the most recent date.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-05-2023 07:54 AM | |||
08-08-2024 10:58 AM | |||
12-28-2022 11:18 AM | |||
06-16-2024 03:22 AM | |||
08-21-2024 05:25 PM |
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |