Femke's website
Follow Femke on LinkedIn
Femke Kooij is a dashboard and report designer, developer and educator specializing in SAP | BusinessObjects Dashboards (better known as Xcelsius) and Crystal Reports. She has also a lot of experience with other SAP | BusinessObjects toolings like, Web Intelligence (WebI), Information Design Tool (Universe Designer), BusinessObjects Data Services (BODS) and the overall server platform BusinessObjects Enterprise (Launchpad, CMC). She spends a lot of her time thinking about and sharing her knowledge of Xcelsius to others through her own blog. Lately she is exploring other visualization tools like Qlikview and Tableau. On the later she is also posting some experiences. Currently she is in the employment of Cognizant Technology Solutions. Her blog only contains her personal views, thoughts and opinions. It is not endorsed by Cognizant Technology Solutions nor does it constitute any official communication of Cognizant Technology Solutions.

Tableau: Trend chart Previous Years in Current Year

Posted on December 29, 2014 by . Filed under Tableau | Leave a comment

Use the following formula to display Current and Previous Years trend lines while having a Relative Date filter: Relative Date: DATEADD(‘year’,DATEDIFF(‘year’,[Order date], today()), [Order date]) This formula will add 4 years to orders made in 2010 (if current year is … Continue reading →

Filed under Tableau | Tagged , , , | Leave a comment

Tableau: toggle between charts

Posted on December 17, 2014 by . Filed under Tableau | Leave a comment

If you need to toggle between charts you have to: – create a sheet for each chart – create 1 string list parameter, which you place on each sheet, display parameter – create a calculated field referencing the parameter – … Continue reading →

Filed under Tableau | Tagged , , , | Leave a comment

Tableau: Order of Execution

Posted on December 16, 2014 by . Filed under Tableau | Leave a comment

Order of Execution in Tableau: Computed in the database: 1. Context filters 2. Top N and conditional filters 3. Regular quick filters Computed in Tableau: 4. Table calculations are computed 5. Table calculation filters are applied 6. Reference lines This … Continue reading →

Filed under Tableau | Tagged , , , | Leave a comment

Tableau: Filter with context

Posted on December 16, 2014 by . Filed under Tableau | Leave a comment

I had to apply a filter on a Top N chart; select a Region, then display Top N States. When I added Region to the filter section. it showed me from the Top N states overall, only the states in … Continue reading →

Filed under Tableau | Tagged , , , | Leave a comment

Tableau: Waterfall chart from Budget to Actual

Posted on December 10, 2014 by . Filed under Tableau | Leave a comment

It has been a while since I posted anything. Currently I am exploring Tableau Software, as I encounter some challenges as well, I decided to post those in a separate section. This will be the first post. I did not … Continue reading →

Filed under Tableau | Tagged , | Leave a comment

Do you know these tricks?

Posted on April 4, 2013 by . Filed under Components, Design, Excel | 1 Comment

During the last couple of months I have discovered some usefull tricks, which in turn are too small for a post on its own, so I have combined them into this one. Formula for calculating the maximum scale for chart … Continue reading →

Filed under Components, Design, Excel | Tagged , , , , , | 1 Comment