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?