-
Embed Page/Story and update filters via javascript postMessage
hi all, we embed cards and pages/stories in iframes on our platform. We have some filtering options that build the pfilters query parameter, and reload the cards/pages iframes when those filters are changed by the user. This will fully reload the iframe. Im looking into a solution where we push the filter information into…
-
Use BeastMode calculation as column with Dataset query api?
Its is possible to select a beastmode calculation column in the query set API call? Im trying something like: {"sql": "SELECT realColumnName, beastmodeCalculationName FROM table"} and the result is There was a problem executing the SQL query: Invalid column(s) referenced We use a similar query in our custom domo app with…
-
Hide row in html table if column data is empty
Hi all, We have a business rule where we only show data if the number of rows is >=7 because of privacy/pii concerns, and we do that with a beast mode calculation, and apply it as filter CountRespondents: SUM(COUNT(DISTINCT `ratingid`)) OVER () But when I want to filter/hide the rows where the Comment is empty, the…
-
Use pfilter to limit data to 50 rows
For an embedded card, we want to limit the used rows for the visualisation to eg 50. We use PFILTERS to filter the data for a specific client, so that data is already filtered. Is there a way to limit the data to the most recent 50 rows? (the card is already sorted by date column)
-
md5 or sha1 in beast mode
Does beast-mode support functions like md5 or any alternative?