-
Dynamic PDP
What could be stopping data from showing after applying a dynamic PDP? I created a dashboard that has about 5 ETL Datasets. I then created a user lincesed group of 27 people and all theses users I created an attribute called GROUPING and assign the locations they can only access or see that locations' data. I then set a…
-
NESTED BEAST MODE
Hello guys, I am little confused with how this new nested beast mode function behaves. My understanding is this was here to help using other beast modes in other calculations easily. I have a beast mode calc which works perfect: To prevent me from retyping the case statement above in another beast mode, I could just call…
-
Beast Mode
Hello All, I am trying to find a better way to code this because I think the calculation may be faltering somehow. Alpha calculation is just a sum of amounts Beta calculation is just case pulling numbers from different fields. Mas field- what I am trying to achieve is simply to divide Alpha by Beta It seems to work somehow…
-
Beast Mode
How do I use the name of an already calculated field or beast mode in another calculation. I learnt this nested ability was done last year. We are able to use the PDP new update but can't seem to get the nested beast mode to work. Exam: A=b+c B=d+e Why can't I write another beast mode F= A/B ? rather I have to write it as…
-
Beast Mode
Hello all, I need a little bit of help with this beast mode. I have locations and flags indicator in the dataset. All i am trying to achieve using IN function is, if locations are in A,B,C and flags are Y then HUB else NOT HUB. I just want to bucket HUBS and NON HUBS. The issue there are some that may have both. In other…
-
Beast Mode Filter
Hello All, I have these 2 Beast Mode calc and I am trying to understand why it is not filtering from. (2022-01-01) to (today). What am I missing here please? And with this below too why am I getting error. Any help please? I just want to filter dates from start of previous year to today of last year. 2022-01-01 to same day…
-
Beast Mode Nested
I remember asking about the Nested Beast Modes a little while ago and gladly I read it was part of the new updates on 10/22 DOMO added. How do I make it available in DOMO now please as an admin? thanks
-
Font color
Hello All, I would like to change font color on my table when the data is negative to be red and positive, green. Is a video or a step-by-step tutorial anywhere on how to use beast mode to change font and colors in a table? There aren't any tutorials on DOMO Uni or you tube. I found the HEX codes. Anyone seen documentation…
-
Formating
I have 2 variables of which one must show as currency and other as just numbers. I have tried to concatenate the dollar sign Infront of the main beast mode but I get an error on line 16. What am I missing here?
-
Domo Filters
I am trying to achieve filtering for Current year MTD sales per day. I have written this simple beast mode filter. However, it eliminates totally a lot of data for some locations. It keeps only 3 locations and I know there are data for those dates from all locations. But when I remove the filter all the locations come…
-
Analyzer Data
Hello All, This is a technical question. What could be limiting the amount of data been fed into Analyzer/dashboard even though current data is in the data source? At every step in my ETL I have current data from 1/1/2021 to today, but after running the and saving the ETL when I use it in my analyzer to visualize it, the…
-
ETL Pane
Hi folks, is there a way to group steps in magic ETL into a folder. This becomes very useful when an ETL steps become very complicated and with many other pipelines. After selecting multiple ETL steps - we only have three options (DELETE, DUPLICATE and COPY TO CLIP BOARD)
-
Group By
Anyone knows of a way to GROUP BY in Beast Mode Editor? we can do PARTITIONING but somehow, we can't do GROUP BY? For example: case when 'location'='ATL' then sum((amount)*10) else sum(amount) over (partition by 'Location') end the above works perfect BUT below doesn't. what am I doing wrong here? case when…
-
GROUP BY
Anyone knows of a way to GROUP BY in Beast Mode Editor? we can do PARTITIONING but somehow, we can't do GROUP BY? For example: case when 'location'='ATL' then sum((amount)*10) else sum(amount) over (partition by 'Location') end the above works perfect BUT below doesn't. what am I doing wrong here? case when…
-
Beast Mode
Hello All, I want to build a card comparing cy with py grouped by location. My plan is to use bar chart side by side comparing cy to py. My beast mode calculations seem correct when I create a table with them. When not comparing to PY, I just built a filter to include the dates i need, and it works fine but when comparing…
-
CY vs PY and Multiline Chart
Hi All, I am trying to build a multiline chart that would have 2 Y-axis line chart. Y1 Axis to show Cumulative Line of YTD Sales vs PY to Date Sales and Y2 Axis to show YTD Average Sales vs PY to Date average sales. I have tried all the available line charts and seems not to be the one as per the picture attached. Also,…
-
CY vs PY and Multiline Chart
Hi All, I am trying to build a multiline chart that would have 2 Y-axis line chart. Y1 Axis to show Cumulative Line of YTD Sales vs PY to Date Sales and Y2 Axis to show YTD Average Sales vs PY to Date average sales. I have tried all the available line charts and seems not to be the one as per the picture attached. Also,…
-
Beast Mode
Hello All, New to DOMO and I wanted to check is there a way to reuse an already calculated field in another calculated field instead of re-writing the whole logics again? Example: CF1 = sum(A+B) CF2 = AVG(C+D) Why can't I write a 3rd calculated field as CF3 = CF1 - CF2