Michael Becker
Sisense expert with over 9 years of experience, helping customers to utilise full potential of their data.
- Total activity 889
- Last activity
- Member since
- Following 0 users
- Followed by 5 users
- Votes 59
- Subscriptions 411
Activity overview
Latest activity by Michael Becker-
Michael Becker commented,
Eloy, it would mean that probably you have syntax error in one of your Custom SQL. I'm assuming you are working on shared ECube.
-
Michael Becker commented,
Hi Marina, rankasc is Sisense built in function, it does not exist in SQL. You have to use RANK OVER (PARTITION BY) there.
-
Michael Becker commented,
Hi Kevin, do as follows: - on secondary setup the same measure as in primary, with filter on date for this week - now edit date filter, and go to advanced section of that filter - there you shoul...
-
Michael Becker commented,
Hi Qu, in that section you highlighted, at the bottom there are Other functions (you need to scroll own) There is If and Case there. Please note that CASE and IF work only with measures, so you ...
-
Michael Becker commented,
Hi Steven, this looks to me as data modelling thing, you need to get your data (through Transpose) to stage where table holds all possible dates and users combinations as lines (within date ranges ...
-
Michael Becker commented,
Hi Jessie, make sure to restart both connectors services and close/open ECube Manager. If you got the config right, this should make Connector visible. After that if you encounter additional errors...
-
Michael Becker commented,
You would need to add a plugin for semi circle I think. If you like we could discuss it as we actually develop such things for Sisense. If you would be interested please reach out to me at michael....
-
Michael Becker commented,
Can you elaborate on this one Neil?
-
Michael Becker commented,
Hi Christopher, I would approach it this way: 1 - create a custom column on table with UTC timestamp which will extract month (GetMonth[departure_time_UTC]) 2- create second custom column which wou...
-
Michael Becker commented,
Hi Akondi, yes it should be possible, first of all any ECube you want to connect to has to be running, if it is Stopped it will not be visible in the drop-down.