Hi,
I am attempting to use Desktop reporting to track the 'Days since last use' for Tableau desktop. I created a calculated field - DATEDIFF('day', [Last Report Date], TODAY())
This should show the days since Tableau desktop was last used. however the data is incorrect.
For example.
A user accessed Tableau Desktop and used it 2 days ago, however the report shows it was last used 344 days ago.
Along with this, the report shows users who previously had a licence key but the licence key was reassigned to someone else.
Is there a way to show accurate days since last use? and is there a way to show the users who are only currently assigned a licence key?
Thank you
Hi Amima,
I'm assuming you are connecting to the Tableau Postgress db.
The db is reasonably well structred (forgive me, its been around six months since I was last in the server (beed stuck etl engines for a while now), and it uses a star-schema, with at least one centralised table, not a genuine fact table, but this has correctly identifed keys; it is from this table that you will be able to pull your data.
As for key assignment, you may need to get the list from your admins for cross-matching.
I built a report a while back that gave huge numbers of very similar statistics, report last used date, last refresh date, last user, last team, most viewed pages, busiest times of the day, extract size etc for all 5 thousand workbooks
Steve
