Link to download the Template
For using the template you will need
- A Clockify account: https://clockify.me/signup
- Once you have the account, you will need the API Key. https://clockify.me/user/settings
- If you need more info from the API, here is the link to the documentation.
Things that you can learn
By using and digging into the Clockify Power BI Template you can learn many things:
- Use of functions
Notes on versions
There is a hidden functionality: now you can also use the “reports endpoint” this tables are not enables for load as some personalization will be needed; if you are interested, please go to the Query Editor and search for the tables named “Reports Base” and read the API documentation.
Added “Tasks” table for getting the tasks attributes.
Some users reported errors while loading the file. This errors were solved by adding a “Remove errors” step, just after the “Invoked Custom Function” steps in all the table queries.
UX Work: Conditional formatting on shadows, clearer texts, bigger fonts
UX work — usage of shadows.
Changed the navigation tabs to a navigation bar on the left
R Visual stopped working :(
Added test data option for being able to show snapshots without revealing confidential data
Dynamic Axis Legends
MTD Measures that ignore days in previous month that have not happened yet in current