About salehaxsid

salehaxsid

Implementation of DatesYTD, DatesMTD using LookML is simple, you just have to create another explore with sql_where condition of existing view that has transaction date. For Example:We have a view "Orders" and it has transaction dates as Order_Date a...

salehaxsid

Since Table Calculation works on the front end and displays row count based on the rows visible in a visual, its not possible to return total row count if its more than 5000.You can try creating derived table of product and sales from visual itself b...

salehaxsid

You may have to write the table calculation to get row totals for every look where it will used since row totals have certain limitations when the rows in data are exceeding the limit.

salehaxsid

I was facing the same issue but it was solved by the method mentioned in this post,Aggregating across rows (row totals) in table calculations | Looker | Google CloudHope it helps.

salehaxsid

Hey, You can go through this post, Adding Images to Your Looker Dashboard | by Cyril Toneatto | Astrafy.To customise Look and add image in background you can refer to this doc Create a dynamic dashboard image with Liquid and HTML | Looker | Google Cl...

salehaxsid

You can use dimension with type tier to bucket data according to tier [ >1000, >10000] etc.and create a measure to count tier you will have the result.For reference you can check:Dimension, filter, and parameter types | Looker | Google CloudHope this...

My Stats

thommo's Bio

Badges salehaxsid Earned

Recent Activity

How to implement DatesYTD and DatesMTD using LookML

Re: Show/ display Total report results row count (more than 5000)

Re: sort Row total was not apply in visualize

Re: sort Row total was not apply in visualize

Re: add image background to dashboard

Re: Creating Custom Categories for Income Groups and Tracking Yearly Counts