Best Of
Re: How do I get the following aggregation setup in domo?
That's a bit different. It's not a simple sum, but the sum of the max value by user. That would require a fixed function ( ) that could look like this:
sum(max(number) fixed(by id))
You could still either make 3 cards or create a variable that allows a user to flip between the 3 levels of aggregation.
Sortable Link
We know how to add a link field to a table, using:
Here is a way to get it to be sortable… Insert a throw-away attribute to the left of the link.
instead of
CONCAT('<a href="', `Card Link`, '" target="_blank">',`Title`,'</a>')
UseCONCAT('<a title="', `Title`,'" href="', `Card Link`, '" target="_blank">',`Title`,'</a>')
Then the column will be sortable by the displayed text.
BSovers
Re: Fill down values in a column in DOMO ETL
Hello,
recently I've faced simmilar issue, and managed to find the way with Pyton.
Code of the Python snippet:
====
# Import the domomagic package into the script
from domomagic import *
import pandas as pd
# read data from inputs into a data frame
input1 = read_dataframe('YourDataSetName')
# write your script here
input1['column_1'] = input1['ColumnName'].map(lambda x: None if not x else x).fillna(method='ffill')
# write a data frame so it's available to the next action
write_dataframe(input1)
====
There is also extra change of DOMO's 'empy string' to Python's N/A's.
Re: Manage Color Rules
If you post this in the ideas exchange, other community members will have the ability to upvote the idea. The more upvotes it gets, the greater the chance it has of becoming a new feature.
Re: Mimic Vlookup in Dataset?
@deona720 Joins are the ETL equivalent of vlookup, with a few minor differences. You can read more about joins in this Knowledge Base article. In this case I would recommend creating a branch of your dataflow that filters your input dataset on Log Status = Leave so that you have one row per Member ID that includes the Termination Reason. Then use a left join with the original input on the left and the filtered data on the right, using Member ID as your join field. Drop the Termination Reason from the left table and the Log Status from the right table to mimic the output from your example.
