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.
- 10.6K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 63 Kowaza
- 296 仲間に相談
- 649 ひらめき共有