About genghisk

genghisk · 05-07-2021

Please see attachment,Currently I am having to export the data in excel to do this work. I would love to see if it can be done in Looker.I assume this can only be done in lookML which I have am completely new to. Any help or guidance literature to wh...

genghisk · 04-24-2020

I am a basic user and only have limited access to create custom dimensions and table calculations. Would it be possible with LOOKER to create count order of occurrences? I can achieve this in excel via COUNTIF($a$2:a2,a2) I’m trying to replace a date...

genghisk · 09-20-2022

Hi genghisk I can’t understand your answer.. could you explain further please? I think you got what I’m looking for. I particularly don’t understand where you define this? Is this something to add as a Table Calculation or as a Measure? Category numb...

genghisk · 08-21-2021

@adeel_nazir , @vkathepalli I solved this using just LOOKER table calculations.your category has to be a number, if not already you can change it into first row occurrence by match.Category number: match(${category},${category})Create new table calc ...

genghisk · 08-13-2021

ryan.dunlavy: We can also get the day of week using this same formula and writing in the days for each number like this: index( list("Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"), mod(diff_days(date(2008,01,01), ${orde...

genghisk · 04-28-2020

@Cyril_MTL_Analy Thanks! I was able to achieve it with a similar formula. row()-match(${patient.patient_id},${patient.patient_id})+1 My next challenge, is to pivot that “rank/order” column, which is not possible with table calcs, so each row will be ...

My Stats

genghisk's Bio

Badges genghisk Earned

Recent Activity

How to rank dates per unique ID in a table?

count repeated values to get sequential order of occurrences

Re: Running Total by Category & Date

Re: Running Total by Category & Date

Re: Day of week in custom dimension?

Re: count repeated values to get sequential order of occurrences