Flex Table with only one column
How do I make a flex table with only one column? I don't want more than one columns, but it seems that the flex table input needs at least two columns to work. Could anyone help?
If not, then I was thinking of using a Comparitive Guage as an alternative. However, I cannot make the beast mode calculation as per my needs to work on a Comparative Guage. Here's the two columns I have to use:
Date: Shows date of purchase
Product ID: Shows product ID of sold product
Note: Product IDs can be repeated becaue same product IDs can be sold more than one time.
I have a date filter on my dashboard. Through the presets mode, I can choose any weekly time range: last week, last 2 weeks, last 3 weeks etc.
I want the comparative guage (another card on dashboard) to show the difference between the number of product IDs sold during the last date and the latest date.
I can do this easily with a flex table, but for that I need more than one column.
Comparative guage asks me for previous value and new value. I dont understand how to make a beast mode calculation that takes the distinct product ids for the oldest date selected, and the latest one. Here's my best guess:
Previous value: Count ( Distinct ( Case when 'date' = min('date') then 'Product ID'))
Latest value: Count ( Distinct ( Case when 'date' = max('date') then 'Product ID'))
But this does not work. I think because min('date') is the same date for that row.
Any help?
Comments
-
Hi @hamza_123 ,
Did you try making them making hidden? I suggest you to add multiple columns in table and mark them hidden from general properties window. Make just one column visible.
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"Thanks,
Neeti
1 -
Which column are you attempting to hide? If you want to Hide a column in the flex table you can do this under General settings by selecting Empty from the drop down for the Column #.
You can't utilize a beast mode to do this because the beast mode will look at each row individually. You'd need to calculate the min and max in an ETL before it gets to the card.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
A column appears as a row in the flex table. So i'm trying to hide a rown in the flex table.
0 -
Can you filter that value out via the card filters?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
No I cannot
0 -
Hi @hamza_123 ,
I had a similiar issue in past and I have written a beast mode, and changed the color of column which is a row now. It was somthing like, check if value is 'static_column_name' then change color.
Since beast mode works row wise, I suggest you to give a try based on your static column name(which is a row now).
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"Thanks,
Neeti
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive